Article ID: 161012 - View products that this article applies to.
This article was previously published under Q161012
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article shows you how to use Automation from a Microsoft Access form to start Microsoft Outlook and display a new contact screen for input. You can change just one line of code to make this example apply to a new Microsoft Outlook appointment, journal entry, mail message, note, post, or task.
For information about how to run Microsoft Schedule+ with Automation, please see the following article in the Microsoft Knowledge Base:
147633This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to your version of the "Building Applications with Microsoft Access" manual.
(http://support.microsoft.com/kb/147633/EN-US/ )ACC: How to Run Schedule+ from MS Access Using Automation
The following example shows how to create a form in Microsoft Access that starts Microsoft Outlook from a command button. Then, the Automation code opens a new contact screen for input in Microsoft Outlook. After you enter the contact, and save and close the contact form, the Automation code quits Microsoft Outlook and returns to the Microsoft Access form.
To run Microsoft Outlook from a Microsoft Access form, follow these steps:
For more information about using Automation with Microsoft Outlook, please see the following article in the Microsoft Knowledge Base:
160502For more information about using Automation to work with other programs, search the Help Index for "Automation, overview," or ask the Microsoft Access 97 Office Assistant.
(http://support.microsoft.com/kb/160502/EN-US/ )ACC: Using Automation to Add Appointments to Microsoft Outlook
Article ID: 161012 - Last Review: January 19, 2007 - Revision: 3.3