mattaustin01
Board Regular
- Joined
- Feb 17, 2009
- Messages
- 184
Hi all,
Wondered if anyone might be able to post some sample code for adding an appointment to a different mailbox's calendar from Excel.
Essentially there is a calendar which is viewable by all that I would like to be able to write appointments to using VBA. I have all the information that needs writing in a userform and am comfortable with how to add this to the subject line, body, and edit dates/times/busy or free etc, I'm just struggling to actually create the appointment in the first place.
I'm aware that the CreateItem method only works with your default Outlook Calendar, and have tried and tested several macros from around the web that successfully achieve this. Is it simpler to create it in my default folder then move it to the separate mailbox, or create it in the separate mailbox to begin with?
Any thoughts or sample code would be very much appreciated
Matt
Wondered if anyone might be able to post some sample code for adding an appointment to a different mailbox's calendar from Excel.
Essentially there is a calendar which is viewable by all that I would like to be able to write appointments to using VBA. I have all the information that needs writing in a userform and am comfortable with how to add this to the subject line, body, and edit dates/times/busy or free etc, I'm just struggling to actually create the appointment in the first place.
I'm aware that the CreateItem method only works with your default Outlook Calendar, and have tried and tested several macros from around the web that successfully achieve this. Is it simpler to create it in my default folder then move it to the separate mailbox, or create it in the separate mailbox to begin with?
Any thoughts or sample code would be very much appreciated
Matt
