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.
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.
