• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Using email notification to update calendar events?

Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
#1
Hello everyone and Thank You for your time.

I'm seek for a way to use email notifications that I receive in Outlook 2016, to automatically update event titles in a shared Outlook calendar, that will occur within a 7-14 days period from the date received.

I have filters setup to place the notification into a specific folder in my account. The shared calendar contains all reoccurring events that I’m looking to update the event titles of.

Currently I am manually doing the following: When a notification arrives, I switch to the calendar, find the event then pre-append an envelope (✉) symbol to the event title (but not the entire series). This is a visual indication to others, that share the calendar, an email notification was received for that particular event.

Email notifications are sent out (typically 7-14 in advance of the scheduled calendar event) from a preventive maintenance system as work orders. The work orders are identified by a TE-number. The same TE-number is also used in the calendar event title. I’m seeking to update the current event, of the series, programmable.

TE-number also has an interval identification as a suffixes: W, BW, M, BM, SA, SA-1, SA-2 and A.

Previous attempts to do this on my own just aren't working, so I'm looking to starting over. I have some familiarity with VBA, just need a basic framework to get me going in the right direction. Any help would be appreciated.

Email Notifications
upload_2018-1-13_9-9-33.png


Calendar Events
upload_2018-1-13_9-10-33.png
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#2
it sounds like the emails are formatting something like the sample here - Create Appointment From Email Automatically - in this case, the macro creates a new item. It needs to do a lookup of the calendar using Find or Restrict then update the event.
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#3
The email notifications are actual emails, not meeting updates, correct? When you receive the email notification, does the appointment already exist?

I was going to work on a macro to update but it would really work best if the email can be identified as an update to a previous event - otherwise the macro would need to search the calendar every time a specifically formatted message arrived. Reducing the # of searches would be the better option.
 
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
#4
Yes, they are emails and the events are already scheduled as a series of recurring events.
Both the email subject and event title are identified by the specific TE-number.

In my previous attempts, I could not figure out how to update specific calendar events without changing the calendar series.
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#5
You need to find the series and get the exception - it takes a bit more code. I don’t have code samples that edit an occurrence, only code to find the series and get each date within it, but I think there are some samples at msdn. I’m on my iPad right now and can’t play with any right now though.


Sent from my iPad using Tapatalk