With the help from several “Slipstick” code examples I’ve been able to write an Excel Macro to find all of the AppointmentItem(s) for a full year from an outlook shared calendar. (I’m not real familiar with all of the correct Outlook/Exchange terminology). I use this data to build a BIG wall calendar in Excel showing day-by-day appointments with cell shading to show time allocation, works great.
The problem I’ve encountered has to do with recurrence appointments. I’ve been able to simulate the reconstruction of recurring appointments and, using the “Exceptions”, account for moved appointments and deleted appointments. I have noticed that as I parse through all of the appointment items and exceptions that I seem to be missing a few; the outlook calendar shows the days open for a few appointments but I can’t find the exception indicating it was deleted.
The exception showing deletion has got to be there or maybe there is a way a recurrence appoiment shows it was moved other than by “Exception”. Maybe I’m looking in the wrong place. Has anyone else encountered this and can shed some light?
Thanks
The problem I’ve encountered has to do with recurrence appointments. I’ve been able to simulate the reconstruction of recurring appointments and, using the “Exceptions”, account for moved appointments and deleted appointments. I have noticed that as I parse through all of the appointment items and exceptions that I seem to be missing a few; the outlook calendar shows the days open for a few appointments but I can’t find the exception indicating it was deleted.
The exception showing deletion has got to be there or maybe there is a way a recurrence appoiment shows it was moved other than by “Exception”. Maybe I’m looking in the wrong place. Has anyone else encountered this and can shed some light?
Thanks