HOW TO MAKE GROUP OF E-MAIL TO SEND THEM AT ONCE

[SOHAM]

sir,
we have to send information / circular to our clients who has different
groups - and each group had about 10 to i5 e-mail i/d. and have to send msg.
frequently.

Hence, kindly guide us how to make group to enable us to send them at once

 

[Tony Toews [MVP]]

we have to send information / circular to our clients who has different
groups - and each group had about 10 to i5 e-mail i/d. and have to send msg.
frequently.

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/