Save and Send Sheet only as .pdf in Excel 2010

[maryannh]

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