Create Outlook Appointment from an Access event handler

[Capt Jim Cook]

I'm keeping an activity log and need to review "pending" records that haven't
closed out within 2 hours after they start (start time captured
automatically).

I have a timer event (15 minute cycle) on a form that looks for records
between 2 and 2.25 hours old and it send out an email using Item.Send but it
only works if the Access form is currently open. Additionally, if more than
one person is in the file, it can send multiple emails to followup on the
same event.

I would prefer to create an Outlook appointment (in the calendar of the
person entering the record) when the record is started, so that it will
receive followup even if the Access mdb is not open. [If it is not closed
within 4 hours, I will then send an email to the supervisor.]

What is the object (comparable to Send.Item) to create a calendar
appointment and where can I find documentation on how to use it?

Sincerely,
Jim Cook

 

[Sue Mosher [MVP-Outlook]]

Use the Application.CreateItem method in Outlook to create new items in the user's default Outlook folders. Documentation is in Outlook VBA Help and on MSDN.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers