I know how to use the Sendmail method to send an email from Excel, but
this always makes it necessary for the user to click "Send" to actually
send the file or message. Does anyone know of a way to send an email
from Excel automatically without any user feedback? I've looked a
little at cdo but can't seem to get it to work. Any ideas would be
greatly appreciated.

davenews wrote:
I know how to use the Sendmail method to send an email from Excel, but
this always makes it necessary for the user to click "Send" to
actually send the file or message. Does anyone know of a way to send
an email from Excel automatically without any user feedback? I've
looked a little at cdo but can't seem to get it to work. Any ideas
would be greatly appreciated.

Did you look at Ron de Bruin's site?

http://www.rondebruin.nl/cdo.htm

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]