|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
August 11th 06, 06:29 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Create Outlook Appointment from an Access event handler
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 
|
| Ads |
|
#2
August 12th 06, 02:38 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Create Outlook Appointment from an Access event handler
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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Capt Jim Cook" wrote in message ... 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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook VSTO Appointment Item Delete Event | lg | Add-ins for Outlook | 0 | July 31st 06 10:35 AM |
| Event Handler for Folder Selected | [email protected] | Add-ins for Outlook | 6 | May 24th 06 10:44 PM |
| how do i create a shotcut to the calendar event in the contact ?? | Fhernando | Outlook - Calandaring | 1 | April 20th 06 03:01 AM |
| calendar appointment event | [email protected] | Outlook - Calandaring | 0 | March 8th 06 09:26 AM |
| Create Calendar event | tk | Outlook - Calandaring | 1 | January 11th 06 04:51 PM |
Linear Mode
