Can anyone tell me how to code a mass-emailing function from contacts in
Access?....kinda like a distribution list, and I need to be able to
personalise the email too.

David Ng

The easiest solution is to use CDO (Collaborative Data objects), which is
available (at least ) as part of Outlook 98.  Using CDO, it's easy to
send mail from Access.  You'll have to write a little code, but the
examples in the CDO help file make this very easy. At least, this is what
I did when I had a geek-fest party and sent out invites via email. -- Ken

Hi David,

As Ken Getz has already pointed out, CDO offers the most flexibility.
However, if you can't use the library and sending multiple emails (one per
contact) is ok, then you may want to consider SendObject instead. Here's a
sample...

< http://x4.dejanews.com/getdoc.xp?AN=430005828

 -- Dev

: Can anyone tell me how to code a mass-emailing function from contacts in
: Access?....kinda like a distribution list, and I need to be able to
: personalise the email too.
:
: David Ng

:
:
:

Another option is to do a Word mail-merge. The messages can then be
personalised. Easiest way to do this is to set up an Access query, go to
word and start recording a macro.

Tools|Mail Merge, etc. When you merge the data, there is an option to send
by email, choosing the email address field and adding a subject.

This can also be done from Access via OLE, using word object. I happily send
1,000+ emails a day based on an exported Access rtf report included in the
word document using this method.

And you never invited any of us Access newsgroup regulars?!?!?  How
disappointing.  

Tony <smile>
----
Message posted to newsgroup and emailed.
Tony Toews, Independent Computer Consultant
The Year 2000 crisis: Will my parents or your grand parents still be receiving
their pension in January, 2000?  See http://www.granite.ab.ca/year2000
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

You might automate Word to do it (it's sorta built in, though not terribly
well designed for programmaticaly manipulation).

Or, you might use some kind of control.

Or, you might shell out to the default browser or to an http link file
somehow  .