Hi,
I am wondering if anyone can help.
I am looking to use VBA to email a range on the active sheet the button is on. Range is B7:M33.
I would like the range to be attached to an email in PDF format, I have a another sheet called "Setup" which has the email addresses, subject and body. I am confident coding the to/cc/subject/body etc, however I am having issues creating the PDF.
Ideally I don't want the coding to save the PDF, or if it does have to be saved, can it be saved to desktop and then deleted after the email is sent automatically?
Thank you in advance for any help.
ps. I am using Office 360 so the latest version of excel 2016 if this makes a difference.
I am wondering if anyone can help.
I am looking to use VBA to email a range on the active sheet the button is on. Range is B7:M33.
I would like the range to be attached to an email in PDF format, I have a another sheet called "Setup" which has the email addresses, subject and body. I am confident coding the to/cc/subject/body etc, however I am having issues creating the PDF.
Ideally I don't want the coding to save the PDF, or if it does have to be saved, can it be saved to desktop and then deleted after the email is sent automatically?
Thank you in advance for any help.
ps. I am using Office 360 so the latest version of excel 2016 if this makes a difference.