Emailing each record to different recipient Access 2003

[Ray]

I have a recordset (table) created from a query.
I have a report that prints a separate page fpr each of the records using
individual information from the records.
I have been able get as far as sending the entire report to multiple email
recipients but that is not what I need.
I need to send each page of the report to the email address related to that
pages record from the table.
Is this possible? And if so how?
Is there a way to "step through" the recordset one record at a time and then
send all the emails with one click?
The concept would be similar to a mailmerge function using WORD but I am
working with a standalone db where WORD may not be installed so have created
the form letter fields withing Acess itself.
Any help appreciated.

 

[Mark Andrews]

You can just loop through a recordset and for each record you construct the
email for each person and send it. You would run the report with
a constructed where clause for the current recepient.

You could write this information to a table first and then have one button
which runs through the table and sends the emails out.

Check out our email module it does all of these things and more.
http://www.rptsoftware.com/products/email/
At a minimum you could steal the tblreportqueue table for storing email
history.

A good idea is to sometimes keep track of which emails went out and which
didn't and when they went out, so months down the road you
know who you sent emails to.

HTH,
Mark