email multiple Access reports to individual addresses

[WalkieTalkie]

I have a MS Access 2003 db that produces a report which contains a separate invoice on each page - each page is an individual invoice for each client. Currently the system is that each month I convert these to .pdf, save them, print them, and hand out each invoice to each client.
I would like to start emailing them to each client. Clients' email addresses are contained within the table that I use to generate the report.
My question is: what is the code I need to send an individual page from the report to an individual email address? I am using Outlook as my email software. I hope this is clear enough - let me know if you need more information.

 

[Pampers]

Hi WalkieTalkie,
Your question contains various different issues.
1. email (outlook) automation
2. automatic report creation/pdf-conversion
3. stepping through a customer-recordset

I would suggest tackling issue by issue. Start for instance by how to automatically create a (pdf)-report


Pampers
Keeping it simple can be complicated

 

[pbaldy]

This may get you going in the right direction:

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

Paul
MS Access MVP 2007/2008

 

[WalkieTalkie]

Thanks, Paul and Pampers. Unfortunately it hasn't got me very far - I've been trying to unravel all the code contained in the links you sent, Paul, but I don't understand coding well enough to adapt it for my own database.

Pampers, you have quite rightly listed the steps I need to master. I can automate to outlook OK (step one), and I can step through a recordset to send a file to an email list (step three), but I'm stumped on step two - automatically creating a multiple-page pdf file, and once I've created the pdf file with multiple pages, sending just one unique page to each customer. I'm sure the answer is in the links that Paul has pointed me to, but I just can't work out how or where to use the various codes! Can anyone help?

Thanks,

Miranda

 

[Remou]

Please post the code that you have, even if it is not working the way you want.

 

[Pampers]

Hi Walkie-Talkie,

but I'm stumped on step two - automatically creating a multiple-page pdf file, and once I've created the pdf file with multiple pages, sending just one unique page to each customer.

I don't with this part it is the right way to do it. I think it would be better to create a unique single page pdf for the first customer, create an email, and then go the next customer, create a pdf-report, create email, and so on...

Pampers
Keeping it simple can be complicated

 

[WalkieTalkie]

Hi again
I think you are right, Pampers, and I am working on that approach now. I'll let you know how I get on...

Thanks, Remou, I would post the code, except that there's so much of it - several modules, plus hundreds of lines associated with a form's controls. If you have a quick glance at the link, you'll see what I mean. I'll try and work on a more simple solution for now...

Thanks
Miranda

 

[SeeThru]

With the report, open the report for preview using a WHERE argument, save the report to pdf, email it, then close the report.

Just attaching the report to an email prevent the use of WHERE clauses (in Access97

SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk