Report pages as separate e-mails

Chris RR

Registered User.
Local time
Today, 00:52
Joined
Mar 2, 2000
Messages
354
My Access 2000 system needs to send a weekly e-mail to each user who has open records in the system.

Creating an open item report, with page breaks by user, is a piece of cake. But its there any clever way to separate the pages of a report? If I can write them to separate .txt files, that would work.

I know that I could use VBA to process the User table record-by-record, create a separate report for user, and send them out like that.

Any other interesting approaches?
 
Nope, The best method is to use the separate report for each person.
 

Users who are viewing this thread

Back
Top Bottom