Help with email

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I have a db in access 2003 and I am trying to allow the user to be able to
send a mass email to a list of people in a table by clicking a button. Is
there a way to do this?
thanks
 
Al said:
I have a db in access 2003 and I am trying to allow the user to be able to
send a mass email to a list of people in a table by clicking a button. Is
there a way to do this?
Click to expand...

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 separator character, such as comma or
semi-colon, and then send one email with
all the bcc addresses;
2) individually send the emails.

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm

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.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top