Sending e-mail to multiple recipients

[riggsdp]

I have a question from this page: http://support.microsoft.com/kb/318881



Is it adding all the recipients in the recordset to the To field or just adding one, sending the e-mail, add another, send, etc.?

I need to have all recipients in rstEmails recordset added to the To field and sent out in one e-mail.

[June7]

It is looping through a recordset of addresses and sending message to one recipient at a time.

Revise code to loop through recordset and build TO string then outside the loop, send the email.

[riggsdp]

How would I build the TO string?

[June7]

As I said, open a recordset and loop through the records.

More code examples.
https://www.accessforums.net/access/...ect-17713.html

Bing: access vba email multiple addresses
http://answers.microsoft.com/en-us/o...c-b39976f2c7bf

[riggsdp]

Thanks, got it and all works as I need it to!