Export Outlook Calendar Items via VBA with Recurrences
Posted on 2008-06-10
Firstly, I'll outline what I am trying to do and then what I have achieved so far and the problems encountered
I need a quick 'n' dirty solution to export Calendar Items from Public Folders using Outlook 2000 from Exchange 5.5. My client's server is so old and is going to die *soon* and there is limited backup facilities. Data backup is being affected using a network copy to a more stable machine. Problem is backing up Exchange...
There are approximately 15 Calendars in the Public Folders which need to be backed up. Some of these calendars have recurring appointments and must be re-established for legal implications. Now, I have found some code that will export Calendar Items to a CSV file (Q_22448259) and have managed to pick up the 'IsRecurring' property...but when you try to import the file and map the fields, there is no recurrence item or pattern available
Also, the is some help in Outlook VBA in 'GetRecurrencePattern Method' which allows you to obtain the recurrence pattern and dates etc, but it seems involved if there are more than one type of recurrence
OK...question is...have I missed something i.e. is there an easier way of doing this?
For example - Get a list of all the Calendars in Public Folders & spit out each Calendar in turn to a PST file of the same name?
Unfortunately, time is of the essence and also the prog will become redundant when the new server goes in. I appreciate this could be achieved manually but I am concious of user error. Also, the project is sufficiently large enough with many other potential pitfalls, I do not have the time to really dedicate to making a nice solution quickly
Any help/ideas would be most graciously received