Hello, I have about 20 years of experience with Excel and can navigate tables and queries in Access pretty well. However, I am a novice at the report functionality within in Access... so, I am needing some direction with an issue I'm having.
I have an Asset Tracking database that I have created a report in that is doing exactly what I need it to do in regards to how it groups my report by Holder & Status, and by page. The only problem is that I have between 150-200 Asset Holders at any given time that I need to send a monthly inventory report to. So, I'm trying not to manually create 150-200 individual reports and emailing them to each respective Holder once a month.
I need to see if there is a way when I run the report for it to do the following:
1. Create individual PDF files that names the reports "FAW Small Assets Inventory Report, [Holder], Today()"
2. With a Page of Page Footer that represents the page count for the respective Holder report rather than the overall report
3. Looks up the respective Holder's E-Mail address within a contact table in the database, and emails the respective report to each Holder individually
I don't necessarily need to have a historical record of the PDF file, so I don't care if it saves the PDF to a temporary file location and deletes them once emailed.
This may not be easily accomplished and I know there will likely be additional questions/confirmations in order to help me, but any help you guys could give would be greatly appreciated.