<

Go Premium for a chance to win a PS4. Enter to Win

x

Using Automation to Control Outlook from Access

Posted on
8,973 Points
2,378 Views
6 Endorsements
Last Modified:
Experience Level: Beginner
5:14
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
Comment
Author:TechMommy
1 Comment
 

Expert 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Join & Write a Comment

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month