Upside: It will let those who were previously unable to import Church calendars to do so and therefor be able to sync to their Smart phone as well if they have one. All you have to do is take the reformatted file and import into Outlook as a CSV file using the option to replace duplicates.Дownside: This will not remove previous calendar entries that were downloaded and imported previously but then latter removed from the ward calendar due to cancellation etc. The Macro was written in Excel 2003 & takes the exported CSV file from the calendar and automatically reformats it & spits out a new file in the correct format. Short term: Use my Macro until some one figures out a way to implement it on a Church Server to automatically spit out an Outlook compatible CSV file. Long term: Implementation of the new CalDAV standard across webservers & calendaring applications Due to the previous problem of duplicates this feature has not been used as well as it could or at all for Outlook users who have experienced this problem.

Currently members can only import 12 months at a time & to sync your Outlook calendar on a regular basis requires multiple downloads & imports of files. This is due to the organization and strict column naming requirements of Outlook when importing data. Only problem is the CSV file format exported from the ward/stake calendar is not compatible with MS Outlook 2003 for sure & other versions likely either. When importing iCal files, Outlook does not provide any options such as replace duplicates like you will see when importing a CSV file. This post is for you ).ДЄpparently the implementation of the iCal standard by Microsoft into its Outlook products was not as robust as it could have been according to an inside authority I will not name here. If you have tried to import the calendar from your ward or Stake website into Outlook 2003 or possibly Outlook 2007 and have seen duplicate entries created each time you import.

Csv to ical converter