Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, February 27, 2007 – Permalink –

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

Labels: ,


<Doug Klippert@ 6:08 AM

Comments: Post a Comment