Change code so when it prints tabs to PDF, it uses the tab's name as PDF name?

Hi All,

I got some code from you lovely people to print all my tabs to PDF files and attached them in an email to myself. This will save me loads of time. One thing I'm hoping to add though, is for each PDF to be named the same thing as the sheet it was printed from. So if the sheet is called "Packing List", the PDF file that attaches in the email would also be called "Packing List". I'm hoping this is an easy fix for you geniuses but how to do this escapes my feeble brain.

Will be so appreciative if any of you can help me figure out how to do this!

Please Login or Register  to view this content.

Try to change:

Please Login or Register  to view this content.

Originally Posted by mjr veverka

Try to change:

Please Login or Register  to view this content.

That did it!! Such a simple line to fix it seems at first glance. Thank you for your help; I don't know what I Would do without this community.