EMail Merge in Access

[Kaylen]

Hello,
I have a list of people and their email addressses kept in a database
Access 2003. I would like to be able to send out a personalized email to each
of the people on the list using Outlook 2003. Like mail merge in Word, I
would like to know if I can do the same in Access. If yes, where would I
create the email message in Access that would become the body message of the
email (not attachment)? In a report? For example, Dear "<Last name, First
name> then send to email person with that last name and first name in the
email column of the database. Any direction is appreciated!

 

[Paul Shapiro]

The easiest approach if this is an occasional need is to do the mail merge
in Word. Word can merge to email, using an Access table or query as its data
source. If this is a regularly-occuring mailing, you can find sample Access
VBA code by searching the web for "Access email merge".

 

[Mark Andrews]

We have an email merge product, it works just like you describe.
http://www.rptsoftware.com/products/email/

It does both text and HTML email templates and substitutes your data at
runtime. It can also do various types of attachments and merging of
attachment data into the email.

We prefer using a free SMTP library (works better and more flexible than
sending mail through Outlook, but you could change the code to use Outlook
if you wanted).

Free demo to see how it works,
Mark