Variable Email Address

C

Caroselle

Hello,

Is there a way to go through a query or report that contains a different
email address in each record, and send that individual record to the email
address in it? I know how to create the report, but I do not know how to get
Access to use one of those fields as the To address to send the email.

Thank you.
 
A

Arvin Meyer

Caroselle said:
Hello,

Is there a way to go through a query or report that contains a different
email address in each record, and send that individual record to the email
address in it? I know how to create the report, but I do not know how to get
Access to use one of those fields as the To address to send the email.
Click to expand...

See the following code:

http://www.datastrat.com/Code/MultipleEmail.txt

You will still need to link attachments individually, but you can do that
with a separate loop which looks at a recordset key and creates the
attachment, or fills the body of the email based on the value of that key.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top