Excel VBA - controlling Outlook calendar

  • Thread starter Thread starter gerok
  • Start date Start date
G

gerok

I want an Excel macro that can be used to add e.g. appointments i
Outlook's calendar. Through an userform in the macro I want to choos
start- and endtime, location and so on.

Is there any possibiliy to acces the Outlook calendar from Excel VBA?

Thanks in advance!
Georg Rokn
 
Yes, there is a way

refer to the Outlook library and you can use all functions of Outlook.

Code like that:

Dim OutApp As Outlook.Application
Dim OutMail As Outlook.AppointmentItem
Set OutApp = CreateObject("Outlook.AppointmentItem")
and so on.....
 
Back
Top