Out look express-insert values in body of the letter though VBA code

[Shetty]

Dear All,

I am using outlook express as mail client

I want to send report directly from excel through vba code. report must be
appended to the body of the letter

how to create object and send mail
how fill address : to, :cc, :bcc

Please guide me

thanking you

ramesh shetty

 

[Roger Govier]

Hi

I don't think Outlook Express supports this, only Outlook.

The place for information on using various methods of sending email is Ron
de Bruin's site
http://www.rondebruin.nl/sendmail.htm

 

[Ron de Bruin]

For the OP

With SendKeys but without attachments it is possible

See
http://www.rondebruin.nl/mail/oebody.htm

You have more options if you use CDO
http://www.rondebruin.nl/cdo.htm