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?
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?