So sort of like Conditional formatting where it changes colour - instead it
adds rules to send an automatic email... Is this reaching for the stars?

Start here Reload Internet
http://www.rondebruin.nl/mail/change.htm


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


"Reload Internet" <Reload wrote in message
...
So sort of like Conditional formatting where it changes colour - instead it
adds rules to send an automatic email... Is this reaching for the stars?

I bet VBA code could do this, but it's way over my head.

Good Luck!

Thanks!
But you can just give me the complete thing to paste in assuming it was cell
A1, value 200 + and I will set up my smtp server etc.

I was a bit confused by where to place the macro

"Reload Internet" wrote:

So sort of like Conditional formatting where it changes colour - instead it
adds rules to send an automatic email... Is this reaching for the stars?

Hi

I was a bit confused by where to place the macro

Read this
http://www.mvps.org/dmcritchie/excel/getstarted.htm
And
http://www.mcgimpsey.com/excel/modules.html

And then see if you can use CDO


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


"Reload Internet" wrote in message
...
Thanks!
But you can just give me the complete thing to paste in assuming it was cell
A1, value 200 + and I will set up my smtp server etc.

I was a bit confused by where to place the macro

"Reload Internet" wrote:

So sort of like Conditional formatting where it changes colour - instead it
adds rules to send an automatic email... Is this reaching for the stars?