Doesn't CDO require some applications (IIS, Exchange, etc.) to be
installed first? I don't think it's a part of operating system.
I would use a 3rd party library. My "weapon of choice" is SMTP
Component
http://www.ostrosoft.com/smtp_component.asp
Or just search Google for +SMTP +Excel +VBA
hs234
On Thu, 22 Jul 2004 12:24:47 -0400, "Tom Ogilvy"
wrote:
Ron de Bruin has code that uses CDO to send the mail and avoid the prompt.
Ron de Bruin's site
http://www.rondebruin.nl/sendmail.htm