Macro to convert sheet to pdf then send via Gmail

pimp_mentality

New Member
Joined
Oct 15, 2015
Messages
46
Hey Guys,

Been a while, hope you'll can help me out.

I am working on userform to help sort data and view in a more concise way. I am however now at a point where I would like a macro which will allow me to convert the sheet with a form (which was populated via the userform) to PDF then send, via Gmail, as an attachment, to multiple recipients. The email information i.e. recipients email addresses and the senders email address I would like inputted into the userform in predetermined textboxes and a button will trigger the email. I would also like the pdf document after it is sent to be saved to a file on my desktop.

I have been doing some research and cant seem to find a code which work adequately for me. Any help re this Macro would be greatly appreciated as my project is almost at the finish line.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top