Bulk email from a query

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

I have a query which results in a list of email addresses. I would like to
be able to send an email to all of them at once say from a button on a form.

Can anyone suggest a method for this.

The query name is qryBulk_email and the field name is stremail_address.

Thanks
 
Les said:
I have a query which results in a list of email addresses. I would like to
be able to send an email to all of them at once say from a button on a form.
Click to expand...

See the Sample Code illustrating looping through a DAO recordset page
at 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
 
Tony I have looked at your code but I cannot understand where it picks up
the email address from. My field is called txtemail_address. Where does
this go in the code?

Can you guide me further on this one please.

Les
 
Back
Top