Send Email When Cell Value Changes

[jonah]

Hello,

There is a single, critical cell in a workbook that i need to be
notified when the value changes in any way. I would like to be
notified by email. My office runs on Exchange Server and Office 2003.

The value might change a couple of times prior to saving, so it
would be best if the email that was generated was done after saving and
on closing the spreadsheet.

I do not need to send the worksheet or any data, just a note that
states that the critical cell has changed.

Any help would be appreciated.

jonah

 

[Ron de Bruin]

Hi

Try
http://www.rondebruin.nl/mail/change.htm

 

[jonah]

Hi Ron,
I had seen your posted suggestion before and hoped you would refer
me to it yourself. The difficulty i'm having is amending the
worksheet_change to recognize that the cell has changed in any way, not
just over 200.

I'm assuming that i insert the Mail_CDO as 'yourmacroname' when i've
got the Worksheet_change sub recognizing the changed cell.

jonah

 

[Ron de Bruin]

Hi jonah

Remove the test then

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("A1"), Target) Is Nothing Then
YourMacroName
End If
End Sub

I'm assuming that i insert the Mail_CDO as 'yourmacroname' when i've
got the Worksheet_change sub recognizing the changed cell.

Correct

 

[jonah]

Ron,
Thank you for this help. I've got the Worksheet_Change event
running and can prompt simple macros to run. However, the Mail_CDO
macro stalls on .Send. The Error message i get is:

Run-time error '-2147220960 (80040220)':
The "SendUsing" configuration value is invalid.

Any help would be appreciated.

 

[jonah]

Ron,

It's okay, i just figured it out! Thank you for your help!

jonah