Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
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



  Saturday, March 15, 2014 – 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@ 3:16 AM

Comments: Post a Comment