Classic save as PDF and email but with some major twists

[ben_sorensen]

Hello

I have seen different variations of this but I haven't been able to figure out how to make it work for me.

So I have a workbook that has many different variations of worksheets, each worksheet goes to a different store.

First a page would be saved as a pdf, with each PDF having specific name and stored in it's own store file, then that PDF would attach to an email and the email would be address to the store general manager and the market manager, the subject of the email would have some standard text in it with the date and the body of the email would have some specific data points specific to that store.

I have seen some examples of this but nothing that has really been able to get the job done.

Any help would be greatly appreciated.

Best