Sending Email from Excel VBA

[AmirSoft]

Hi Experts!

I am using the following code send email from Excel. But this do not show any error. But not sending an email.

Please Login or Register  to view this content.

Please give me a solution.

I shall be very thankful to you.

Regards
Amir

[Subverter]

It is a good idea to use Outlook to send e-mails while working with workbooks ..
Try out the next code ...

Please Login or Register  to view this content.

[humdingaling]

Please Login or Register  to view this content.

you have no username or password set?

here is more reading for CDO
http://www.rondebruin.nl/win/s1/cdo.htm

[humdingaling]

also bare in mind you may need to change configuration of Gmail

here is a previous thread using CDO gmail
http://www.excelforum.com/excel-prog...l-program.html