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

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

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

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

--
Regards
Roger Govier



"Shetty" wrote in message
...
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

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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message ...
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

--
Regards
Roger Govier



"Shetty" wrote in message
...
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