Bulk Email from Access

[Hardboiledegghead]

I have a query that pulls up names of individuals that I would like to send
email to. However I cant get the SendObject macro or anything else to
recognize more than one name. Does anyone know a way in which a text box can
show more than one record and separate by a semicolon? I would like to have
the TO field populated with the names and instead of going Next Record, Send
- Next Record, Send that would take a long time for the mass email list I
have.

 

[Tony Toews [MVP]]

I have a query that pulls up names of individuals that I would like to send
email to. However I cant get the SendObject macro or anything else to
recognize more than one name. Does anyone know a way in which a text box can
show more than one record and separate by a semicolon? I would like to have
the TO field populated with the names and instead of going Next Record, Send
- Next Record, Send that would take a long time for the mass email list I
have.

1) If you want to send the same email to many people you want to use
the BCC option. I would very upset to find my email address along
with a bunch of other email addresses.

1a) However some spam filtering systems may see BCCs as being more
spammy than others sent using the To.

2) 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.

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
http://www.granite.ab.ca/access/email/recordsetloop.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/