I trying to take a payroll report and create a pdf for each driver's pay and email it with outlook. I’m able to create one pdf with all records and email it (great for accounting), but don’t want to share payroll with all drivers. We don’t have many drivers 20+, so having 20 popup windows within outlook of drafts is not an issue. I have been researching with no clear idea of how to accomplish, would like one command button to create all emails if possible (not clicking on a button for each driver, don’t want accounting to miss a button). Driver email address is already in the report. Any advice would be greatly appreciated, not strong with creating VBA code but comfortable tweaking it.
Multiple pdf's to multiple emails from a report
- Thread starter earls
- Start date
- Local time
- Yesterday, 22:06
- Joined
- Aug 30, 2003
- Messages
- 36,157
I read this article before posting for help, from what I determine all his references take a single report (all 10 pages) and send that same report to multiple people. I’m interested in taking that 10 page report and only sending a single page that belongs to that driver. 10 pages 10 emails 1 page per recipient.
Similar threads
