VBA Code to send Email through Gmail

skamat · Feb 26th 2013

I was wondering if the following is possible.
To create a VBA code so that when the commandbutton is clicked the selected sheet gets transformed to PDF format, and sends the email through Gmail. In gmail it should open the Gmail account automatically by writing the username and password and opens the compose, and attaches the PDF file it created.

**royUK** · Feb 26th 2013

Re: VBA Code to send Email through Gmail

I have code to use email, but the conversion to pdf would depend on your Excel version.

skamat · Feb 26th 2013

Re: VBA Code to send Email through Gmail

My Excel version is 2007.
It would be great if you have the code for Gmail

**royUK** · Feb 26th 2013

Re: VBA Code to send Email through Gmail

I'll see what I can do. You will need to download the pdf addin from MS - it's free

skamat · Feb 26th 2013

Re: VBA Code to send Email through Gmail

ok

VBA Code to send Email through Gmail

Participate now!

Share