If you run Win 2000 or win XP you can use CDO(for Win 2000)
Read the info on the webpage
http://www.rondebruin.nl/cdo.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


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