I have a multipage workbook. What I am wanting is that when a button is clicked, for it to open up the save menu to save one specific page into PDF (worksheet called "Absence Memo"). Once saved, I want it to embed the same page into an email.

Is this possible?

Please let me know if you require any more information.