I have a large workbook that I would like to be able to choose specific sheets to save as .pdf and email via Outlook.
More specifically:
Sheet name: "Purchase Order" and the email address is in B14, SaveAs name in B9 and "Project #" from M4, add a space and "PO"
It would be great if the macro could be initiated with a Button on the sheet.
Thanks for any help, I'm new to Macros and have learned so much from the Forum already!
Maryann
More specifically:
Sheet name: "Purchase Order" and the email address is in B14, SaveAs name in B9 and "Project #" from M4, add a space and "PO"
It would be great if the macro could be initiated with a Button on the sheet.
Thanks for any help, I'm new to Macros and have learned so much from the Forum already!
Maryann
