Invoke Outlook Express SendMail From Excel VBA

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Can the Outlook Express Send email window be invoked from
Excel VBA?

I would like to popup the Outlook Express Send email
Window with the destination address and subject lines
filled in with the info I specify. The user then
completes the email msg and send's it.

I do not want to include my workbook or worksheet in the
email so Excel Sendmail will not work.

I've found some examples for Outlook that popup the email
Send window, but none for Outlook Express.

If this is not possible, are there any other suggestions
to popup the email Send window?

thanks.
 
Ron, thanks for the quick response, it works great.

I looked at your web site earlier but was unable to
identify which two lines to delete.

thanks again.
-----Original Message-----
Hi Alan

See this example for OE on this part of the website
http://www.rondebruin.nl/sendmail.htm#body

Remove this two lines

Application.Wait (Now + TimeValue("0:00:03"))
Application.SendKeys "%s"


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"Alan" <[email protected]> wrote in
message news:[email protected]...
 
Back
Top