Hi Ryan

You can try this
http://www.rondebruin.nl/mail/change.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ryan" wrote in message ...
I find myself in need of a way to send an email via excel when a cell gets to
a certain value. I have the recipients email in A1. In B1 I have the number
of days remaining till his certification expires. B1 is dynamic and changes
every day so thats not the issue. I need a way to email the address in A1
when B1 drops below 30.