(Note: Question has been previously posted in Access forums; got some great
ideas but not specific answers)

Seeking code/examples, etc. for:
* Employee is registered for a company training class in Access 2003 (I have
this).
* As part of the confirmation, an appointment is created in the employee's
Outlook 2003 calendar with a reminder for the class (need this).

I have located a number of resources that have code for creating an
appointment in Outlook from Access. All of these examples create the
appointment for the active user. I can not, however, find any way to send an
appointment with custom info (for training class) to another person
(attendee).

The closest solution I have right now is to generate a customized
e-mail message to attendee with text that reminds them to create an reminder
/ appointment for the upcoming class.

Any ideas, links, code, etc.?

Thank you in advance,

--
Dawn B.

See http://www.outlookcode.com/codedetail.aspx?id=88 for a code sample that shows how to send a meeting request to another user. This would be another alternative:

1) Create the appointment in the calendar of the local user.
2) Use the AppointmentItem.ForwardAsVCard method to create and send a message with that appointment attached.
3) Delete the local copy of the appointment.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Dawn Bjork Buzbee" wrote in message ...
(Note: Question has been previously posted in Access forums; got some great
ideas but not specific answers)

Seeking code/examples, etc. for:
* Employee is registered for a company training class in Access 2003 (I have
this).
* As part of the confirmation, an appointment is created in the employee's
Outlook 2003 calendar with a reminder for the class (need this).

I have located a number of resources that have code for creating an
appointment in Outlook from Access. All of these examples create the
appointment for the active user. I can not, however, find any way to send an
appointment with custom info (for training class) to another person
(attendee).

The closest solution I have right now is to generate a customized
e-mail message to attendee with text that reminds them to create an reminder
/ appointment for the upcoming class.

Any ideas, links, code, etc.?

Thank you in advance,

--
Dawn B.