email address transfer from table

  • Thread starter Thread starter Molly
  • Start date Start date
M

Molly

I'm using Microsoft Access 2000 and trying to figure out
how to transfer the email addresses from a column in the
table to a useable form to make a mailing list (i.e. how
to put all those addresses into the "To" heading on an
actual email). Can anyone explain how to do this, using
layman's language?
 
Molly said:
I'm using Microsoft Access 2000 and trying to figure out
how to transfer the email addresses from a column in the
table to a useable form to make a mailing list (i.e. how
to put all those addresses into the "To" heading on an
actual email). Can anyone explain how to do this, using
layman's language?
Click to expand...

Layman's language, no. This requires VBA coding and looping through a
recordset.

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
 
Back
Top