Sweedler
Board Regular
- Joined
- Nov 13, 2020
- Messages
- 114
- Office Version
- 2016
- Platform
- Windows
- MacOS
Hello
I am working on a template for a customer that has several different tabs. The customer has asked me to provide a Macro that allows them to print to PDF and then send as an email. Now I realize that the easiest would be to put a button on each page, but that risks sending multiple emails (one tab/document at a time) and I don't want that. I also need to gather the email address, either from the document or via entering it.
So, I thought that a Macro that allows me to select which tabs I want to send, select the email address to send to and perhaps add a shorter message to the email. Anyone have any good ideas on this matter.
Does anyone have any good ideas here?
I am working on a template for a customer that has several different tabs. The customer has asked me to provide a Macro that allows them to print to PDF and then send as an email. Now I realize that the easiest would be to put a button on each page, but that risks sending multiple emails (one tab/document at a time) and I don't want that. I also need to gather the email address, either from the document or via entering it.
So, I thought that a Macro that allows me to select which tabs I want to send, select the email address to send to and perhaps add a shorter message to the email. Anyone have any good ideas on this matter.
Does anyone have any good ideas here?