Find all deleted recurrence appointments

Not open for further replies.


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?

Once it's deleted, there is no record for it. If you change the end date, the pattern is regenerated (and exceptions deleted), but you already know the patter - you just want the exceptions.
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
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.
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.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M How can we find the list of users who are members of a deleted distribution list? Exchange Server Administration 2
S Related messages show in main Outlook window vice new Advanced Find windows Using Outlook 1
mrrobski68 Issue with Find messages in a conversation macro Outlook VBA and Custom Forms 1
O How to find out the domain and server settings that my Outlook is using? Using Outlook 2
T How to find or display the sub-folder name for an Archive Search Using Outlook 10
Bardiferous Weird Contacts Behavior - Can't find any in any address book, but they're in there Using Outlook 3
J search doesn't find anything Using Outlook 1
M Issues with templates - unable to find in old web app Using Outlook 3
O How to find and replace a word in Outlook-Agenda-Subject and Message? Using Outlook 0
B Search and Find Email by Folder Name Outlook VBA and Custom Forms 2
Witzker How to find all emails from and to a contact in OL 2019 Using Outlook 6
S How to find emails that I sent that have not received a reply? Using Outlook 7
K Use VBA to find Sender and Recipient from Microsfot 365 Journaled Email Items Outlook VBA and Custom Forms 3
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
H Outlook 2003 find by "has attachment" Using Outlook 1
geoffnoakes Find Contacts with UDFs "in this item" Using Outlook 1
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
B Outlook 2010 Can not find a certain file in M/S Outlook 2010. Using Outlook 1
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
S Find a cell value in excel using outlook vba Using Outlook 1
B Looking to filter (or just find/search) for only messages that the sender has sent more than 1 messa Using Outlook 2
B Search: Cannot find which Folder Contains a Message Using Outlook 3
K How to find specific header and copy the mail body Using Outlook 0
Hudas VBA find and open an email without looping thru each email in the inbox Outlook VBA and Custom Forms 1
E How to find or recover Lost e-mails within a folder under Inbox? Using Outlook 2
H "Advanced find: column for full folder path? Using Outlook 1
M What is the best way to find all records of an e-mail for our company? Outlook VBA and Custom Forms 2
mrje1 Is there a Find and Replace feature in Outlook 2016? Using Outlook 4
G Can't find contacts entered Using Outlook 0
Connie Boyer Exporting Outlook calendar/find next repeating meeting Using Outlook 3
B Find related messages to sender Outlook VBA and Custom Forms 7
B Find Related Emails to sender Using Outlook 1
RBLampert Outlook "can't find" my e-mail server to receive messages Using Outlook 22
M Can't find messages Using Outlook 4
Diane Poremsky Find the Distribution Lists a Contact Belongs to Using Outlook 0
T Macro to find contacts by category and copy them to another folder Outlook VBA and Custom Forms 15
thomas zaleski Cannot find the Sending FOlder Using Outlook 2
J Find and Highlight text in outlook Outlook VBA and Custom Forms 4
J Outlook Mailbox cleanup; any way to change limit to find items older 999 days? Exchange Server Administration 2
F Disable "Find related messages" Using Outlook 1
Jennifer Murphy Can't delete or even find task attachment Using Outlook 1
K Re: Use Instant search to find messages from a contact Outlook VBA and Custom Forms 6
Andrew Hawkins "Advanced Find" Using Outlook 1
M BCM 2007 Can't find SS2012Express Using Outlook 2
O Outlook 2013 contacts - Where to find "Display as"-field Using Outlook 2
A Advanced find query facilty Help please Using Outlook 2
C Cant find emails after moving pst Using Outlook 1
G Find Organizer of appointment Using Outlook 2
R writing "Instant Search" queries to find User-Defined fields Using Outlook 0
P Outlook Advanced Find Using Outlook 0

Similar threads