March 30, 2021
I am trying to write a macro that exports the active worksheet as a PDF, with the name already filled out. Then attach this file into an email, with the email list in the worksheet outside of the print area.
The macro I currently have works if I separate the PDF and Email sections of the macro, however it currently can not roll over from saving the PDF to sending the email.
Any help would be appreciated!