I have a spreadsheet with approximately 40 tabs that I update daily. Each tab records sales metrics for a single person.
Every day, I need to send each tab to the appropriate person.
I'm looking for a solution that will automate the process. Once I finish updating every tab on the spreadsheet, I want to be able to send them out as PDFs to the folks who need the information.
The process would:
1. Automatically convert each tab within the Excel spreadsheet into a standalone PDF, which is named the same as the title of the tab.
2. Automatically e-mail each PDF to it's associated owner (without me needing to create a new e-mail, attach the PDF and send individually).