Take a look at these sites:

Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/index.html

Dick Kusileka's site
http://www.dicks-clicks.com


--
Regards,
Tom Ogilvy


Zeta wrote in message ...
Dear all,

I'm a bit of a newbie but been getting on OK with macros/Visual Basic
using
Excel 2000. Can somebody please explain in simple terms how I can write a
macro to send an email, lets suppose I have vairables: recipient and
subject. I want the message body to be quite complex can I simply copy
and
paste data from a work sheet into my message body?

What commands do I need to send an email?

Also I would like to know if it is possible to format a cell as an email
address, if the contents have been placed in the cell by a variable? If I
tye an email address into a cell then it formats as defaut to an email
address, but when I use VB to change a cell containing an email address
the
address is in plain text and not a hyperlink.

TIA

Zeta