<

Using Automation to Control Outlook from Access

Posted on
9,688 Points
3,088 Views
6 Endorsements
Last Modified:
Published
Experience Level: Beginner
5:12
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access application can launch Outlook, and create email messages, calendar items, and contacts.

Video Steps

1. Create a reference to the Outlook application object.

2. Write code that launches Outlook, and creates an email message, a calendar item, and a contact.

3. Explain that other commands can be used to programmatically control Outlook.

6
Author:TechMommy
2 Comments

Comment

by:bodywise
Very nice.  The screen is too small to read.  It would have been more illustrative  if you would have included the vb file.
0

Comment

by:Billy Schwall
There isn't closed captioning. Not accessible for deaf/hard of hearing people.  :(
0
OST to PST conversion is not a complicated task for Outlook users if they are guided in the right way. This article will guide the users who are not aware of how to transfer Outlook email from OST to PST format.
I found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use.  Here is how I added one to a Microsoft Access database. Please see the important note at the bottom of this article regarding compati…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month