View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Invoke Outlook Express SendMail From Excel VBA

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)
www.rondebruin.nl



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