Can Excel email someone when a cell goes + or - a value?

[Guest]

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?

 

[Ron de Bruin]

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

 

[DNA]

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

Good Luck!

 

[Guest]

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

 

[Ron de Bruin]

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