Batched emails

[Trainingjason]

Hi

I have been asked to set up a batch email system for invoices. I am using Access reports to display the many different invoices prior to printing or emailing.

I then want to email each page of the invoice to the right person. Is this possible in access, and if so how?

Regards



Jason Douglas

 

[B827]

Assuming you have the e-mail address in your Customers table then I think I would write a piece of code and a dedicated query/report to do this. The code will loop round the list of customers to be invoiced, and you could rewrite the sql of the query (selection by customer id) of the individual customer invoice then e-mail the report. I would e-mail the reports to myself a few times with the e-mail address of the customer included int he message text until you are certain it works. I haven't included any code in this post beacuse I'm sure there are more sophisticated methods. Sandy