open outlook from excel to email out
 

i have a code that sends an excel worksheet/workbook to a recipient. but the
problem lies when the user does not have microsoft open to email the sheet.
the email just sits in the outbox waiting for the user to start the
application and then sends it out - sometimes days later; is there a code
that can be used in excel (script) to open microsoft outlook and acutally
email it also?

open outlook from excel to email out
 

see if you can find something on ron's site
http://www.rondebruin.nl/sendmail.htm

--


Gary


"jatman" wrote in message
...
i have a code that sends an excel worksheet/workbook to a recipient. but the
problem lies when the user does not have microsoft open to email the sheet.
the email just sits in the outbox waiting for the user to start the
application and then sends it out - sometimes days later; is there a code
that can be used in excel (script) to open microsoft outlook and acutally
email it also?