Ron has a section on his web site that deals with email.

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


"Larry" wrote in message
...
I have an excel file on my website that customers can open to receive
activation numbers. After the VBA code gives the activation number, I
need
the VBA code to send an email to my address. Can someone show me sample
VBA
code to open a new email, add the address, Subject, and message and send
the
message. Any help would greatly appreciated.
--
Larry