Send Outlook Appointment via E-mail from Access 2007

[Brian]

I have a database in which a user enters data about projects for followup by
another user. Right now, the "other" user must enter that database and
determine what followup needs to be done. Since the "other" user uses
Outlook extensively, I was hoping that I could take the data in Access and
send it to the "other" user as an appointment with a reminder. The
appointment would then appear in the Outlook calendar.

I've Googled til I can Google no more, and have found a lot of info on how
to add an appointment from Access to the local copy of Outlook, but nothing
on how I can send the appointment via e-mail.

Does anyone know how this can be done using VBA?

Thanks!

 

[PieterLinden via AccessMonster.com]

Brian,

You couldn't have. Go to the MS Website... I'm sure there's code to automate
Outlook there. There's some one Danny's website... www.amazecreations.com,
and some here...

Here's the MS example...
http://msdn.microsoft.com/en-us/library/aa159619(office.11).aspx

 

[Brian]

Maybe my problem is that I don't know what I am looking at, but...

What I see when I look at this code (and I had already looked at the MSDN
site) is that the code will add an Outlook item to the Outlook running on the
same computer that Access is running.

What I am looking for is a way for Access to create an e-mail that invites
the recipient to attend an event or appointment. When they accept, it will
then appear on their calendar in Outlook and remind them when the time comes.

Have I made this clearer??