Creating Outlook Calendar appointments, other than your own e-mail via Access VBA

Copper Contributor

Hello peoples of this community,


I am struggling with the following issue:

In our organization, there is one email that manages the appointments of group events, and one email that manages the appointments of individual consultations. We have an Access template that fills the Outlook appointments, but that fills the appointment in the name of the email that is logged in. We have several employees that are all assigned to different individual consultations, but only one that plans al those appointments. Is there a way to assign the different individual appointments from one account to other accounts?


Set objOutlook = CreateObject("Outlook.Application")
Set objNameSpace = objOutlook.GetNamespace("MAPI")
Set objFolder = objNameSpace.GetDefaultFolder(9)


Here is the code that makes the appointment in Outlook, and fills the template out of an Access database.


I hope I was able to clarify my problem with you, and if there is someone that can help me with this. 


Kind regards,



0 Replies