Please help with email and reports

[DentTec]

I can't think straight anymore. Here is the story

I can print multiple reports with one click using force page break. Can I do the same with emailing them ? I now can email one report at a time only. What are the steps I need to do ?

 

[pbaldy]

This type of thing?

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

 

[stopher]

Or if you want to send multiple reports in one email, try this:

http://www.access-programmers.co.uk/forums/showthread.php?t=208291

 

[DentTec]

Thanks for the links. What I am doing here is to generate monthly statements to my customers. I found the code to output all of my reports as I wanted by looping through my list. I'm working on attaching each report to its own email address.

 

[pbaldy]

Let us know if you get stuck. I use an adaptation of the code in that link to send out monthly statements.

 

[DentTec]

Thanks pbaldy. I got mine done after poking around the web

 

[pbaldy]

Happy to help!