Multiple page reports to individual files

[Gina Maylone]

Good morning all!



Simply put, I need to be able to email statements to members. Some are monthly, some are annually, some are one time. Not all members will received their statements via email, so those members must still receive a paper copy. C

urrently, t

he statements are run in batches and printed. Another hitch, if members are 30 or 60 days late their statements include multiple pages with warnings and payment plans etc. It's been utter joy to get these puppies to print correctly. So the request for emailing them has somewhat boggled my already boggled mind.

I know how to send emails through Access. I just need to be pointed in the right direction on how to get the correct statements to go to the correct members.

I thank you in advance for any advice!
Gina

[pbaldy]

I assume the printed report contains all members and just has page breaks to separate them? You can have a field in the member table to indicate if they want the statement emailed. You can have a dual process for printed/emailed. The first can use this:

BaldyWeb wherecondition

to print the report for just the members who don't want it emailed. Then you can use this (with the related loop) to email a separate report to each email member.

http://www.granite.ab.ca/access/emai...recipients.htm

Since you'll be using the same report, tweak that code so it only filters when there's a value in the form control (you can also use a variable or OpenArgs).