Hi,

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!