Send E-Mail with Access

Automate the drill

You can use Access as a data source and use Word to merge to Outlook. Here, however, is a way to do it from Access itself.

"You can use the SendObject method to send a MAPI mail message programmatically in Microsoft Access. However, the SendObject method does not give you access to complete mail functionality, such as the ability to attach an external file or set message importance.

The example that follows uses Automation to create and send a mail message that you can use to take advantage of many features in Microsoft Outlook that are not available with the SendObject method.

There are six main steps to sending a Microsoft Outlook mail message by using Automation, as follows:

1. Initialize the Outlook session.
   
2. Create a new message.
   
3. Add the recipients (To, CC, and BCC) and resolve their names.
   
4. Set valid properties, such as the Subject, Body, and Importance.
   
5. Add attachments (if any).
   
6. Display/Send the message.

Use Automation to send a Microsoft Outlook message using Access

Access to E-Mail



See all Topics