Group e-mail from Access database??

[TomSoCal]

I have an Access Database of about 400 records, most records have a
character field with an e-mail address for the person in that record.
How can I use these addresses to create a group mailing to all these
people via Outlook Express, or Outlook 2002??

Tom

[David Mitchell]

Tom,

If you searched the group first you wouldn't need to post this! There
are a number of long threads which have links to other websites
(MVP's) which will cover this post.

David

[Tony Toews]

to******@yahoo.com (TomSoCal) wrote:

I have an Access Database of about 400 records, most records have a
character field with an e-mail address for the person in that record.
How can I use these addresses to create a group mailing to all these
people via Outlook Express, or Outlook 2002??

You will need to use VBA code to run through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separater and then send one email with
all the bcc addresses;
2) individually send the emails.

Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.

For sample recordset logic see the Access Email FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm