Book Appointment in Outlook from Access; send to Invitees

[Dee]

Hi

I need to book an appointment from an Access 03 form into Outlook 03
Calendar and send the details to an invitee whose info needs to be populated
from a field on the form
I have got far enough with booking appointments in the Outlook calendar but
this is in MY calendar as opposed to sending an invite to someone.
Any help will be deeply appreciated

Dee

 

[Arvin Meyer MVP]

There are only 2 ways to send the invitation. Either send an email from
Access to the same person, or have Outlook send it. I think the better bet
is to use the Outlook Object Model since you then get all of Outlook's
functionality.

I don't have Ken Slovak's book handy, but he or one of the other Outlook
MVPs should be able to give you whatever code you need, then you can run it
from Access using something like:

Dim objOutlook As Object
Set objOutlook = CreateObject("Outlook.application")