Using a Macro to send data to shared Outlook Calendars

Hello,

I am currently setting up a spreadsheet for my office in which we can enter appointments and use a macro to send them to someone's calendar by selecting their name. I currently have this working and sending to calendars that I have made myself but I am stuck with how to send the data to other people. Currently, my macro looks like this:

Please Login or Register  to view this content.

In which arrCal is a dropdown field that is currently set to go to test calendars that I have made myself. Any help in this would be greatly appreciated as I have been struggling with this for most of the day. If anyone needs any further information about the spreadsheet feel free to ask.

Thanks,

Neilp27

You can use the Namespace.GetSharedDefaultFolder method to access the Calendar folder in another Exchange mailbox - as long as you, or more to the point, the current user has permissions (in Outlook) to do so.

Code snippet - this temporarily creates an email message so it can resolve the addressee to get the correct calendar

Please Login or Register  to view this content.

Partial code only to illustrate the idea, that will not compile.