Send E-mail Message to List of Addresses in Access Query

[J. Mullenbach]

Hello,

The association I work for uses Access 2000 to manage its membership data.
Occasionally I need to send a message to all of our active members. I
created a query to pull up all currently active members who provided an
e-mail address and it returns about 500 records.

In an Exchange 2000/Office 2000 environment, what is the simplest way to add
those 500 addresses as a BCC for a simple text e-mail message?

Thanks in advance.

 

[Tony Toews]

Hello,

The association I work for uses Access 2000 to manage its membership data.
Occasionally I need to send a message to all of our active members. I
created a query to pull up all currently active members who provided an
e-mail address and it returns about 500 records.

In an Exchange 2000/Office 2000 environment, what is the simplest way to add
those 500 addresses as a BCC for a simple text e-mail message?

I rather doubt you could stuff 500 email address in a bcc but here you
go.

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
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