Email one page to an address, next to another...

[kbrooks]

I have a report based on a query, that will fill in a kind of form letter for everyone with a license about to expire. Each recipient (each record) is on a separate page. Currently they print the whole report, stuff each page in different envelopes, and send it through snail mail.

Now they want to send the same thing by email. I've been reading up on how to email a report but I'm kind of stuck. I would want the first page going to one email address (address stored in record), second page to another address, third to another, etc. Is this even possible? I wasn't sure how much time to put into it if I should be going about it a different way.

 

[pbaldy]

This should get you started:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm