Goal: To save Worksheet as PDF and email with Outlook - All done with a Macro Button

Hello. I am trying to figure out the code for saving my active worksheet (Delivery Ticket) as a particular file name with Customer Name and Purchase Order number as filename, by using two cells to combine the filename. Screenshot 2023-08-16 141910.png

..then have that pdf attached in an Outlook email (that is usually already formatted) that will automatically send to my customers' email addresses, utilizing their Company Name & Purchase Order Number in the Subject.Screenshot 2023-08-16 143005.png

If I could have the pdf saved to the parent Customer folder, that would be ideal! Screenshot 2023-08-16 143257.png

I am trying to automate all of this with one Macro Button.

ANY help is GREATLY appreciated!

Thank you so much.

The following will create a PDF from the active sheet. It presently saves the pdf to : "C:\Test\Export" and names the file according data in Range("A1"). The location and name can be changed to meet your needs.

Please Login or Register  to view this content.

You may need to edit some of the above code to meet your needs.