Find all deleted recurrence appointments

Status
Not open for further replies.

CFRBill

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server 2010
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
 

CFRBill

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server 2010
I appreciate your insight, thanks. It just seems strange that while looping through the “Exceptions” I do see instances indicating that a recurrence has been deleted. When confirming using Outlook Calendar GUI I find that this is mostly accurate because I have encountered a few recurrences missing with no indication in the “Exceptions”. I've only seen this a few times but was curious if anyone else has seen this.

Thanks again
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
The exceptions - whether deleted or moved - are so outlook knows what to do with each occurrence in the pattern. The deleted exception is showing you where occurrences in the pattern were deleted. If you move an occurrence then delete it, the exception should show the date in the pattern, not the date it was moved to before deleting it.

There isn't a log showing what was deleted or moved. You have the dates in the pattern and the exceptions.
 

CFRBill

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server 2010
Now I understand. I'm sure there has been moving and deleting which accounts for what I'm seeing, sigh. Again thank you for your insight.
 
Status
Not open for further replies.
Top