Making an appointment in Outlook from Access

[KimstrB]

Is there a simple way to open Outlook in Calendar view from Access 2007? I do not know code, but I have used Access for years.

[ADezii]

I am not 100% sure on this, but I do believe that you would have to use the CreateItem() Method of the Outlook Application Object to create the Appointment, then you need to set its Properties, as in:

Dim objOutlook As Outlook.Application
Dim objAppointment As Outlook.AppointmentItem

Set objOutlook = Outlook.Application
Set objAppointment = objOutlook.CreateItem(olAppointmentItem)

'Set properties of the newly created Appointment here
With objAppointment
  '.Actions = ???
  '.AllDayEvent = ???
  '.Body = ???
  '.Duration = ???
  'etc..
End With

[topher23]

If you're going to use Outlook Automation like this, don't forget to add "Microsoft Outlook ##.# Object Library" as a Reference or use late binding, as discussed in this insight from Adezii: Early vs. Late Binding