<

Watch Using Automation to Control Outlook from Access

Posted on
9,584 Points
2,984 Views
6 Endorsements
Last Modified:
Published
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
Author:TechMommy
2 Comments

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

Expert Comment

by:Billy Schwall
There isn't closed captioning. Not accessible for deaf/hard of hearing people.  :(
0
This is a rather simple but effective way of searching while typing on a Microsoft Access Combobox.
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month