Hi

You should be able to acheive your request without too much trouble if
you are familar with vba.

You will need to setup a macro to check the cells value and then use
excels mail tools to send the email.

Look here for some very good examples
http://www.rondebruin.nl/sendmail.htm

Regards
Shaun


--
ShaunM
------------------------------------------------------------------------
ShaunM's Profile: http://www.excelforum.com/member.php...o&userid=18610
View this thread: http://www.excelforum.com/showthread...hreadid=483284