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

SOHAM <SO***@discussions.microsoft.com> wrote:

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

Windows permissions problem: cannot lock file
Shortcut target path
How can I inhibit the security warning when starting Access with a Shell command?
Legal Timestamp in MS Access 2003
Access to Tables