Send Email When Cell Value Changes

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

Hi

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


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


<jonah@popstar.com> wrote in message news:1147716196.039782.38220@i40g2000cwc.googlegroups.com...
> 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
>

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

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


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


<jonah@popstar.com> wrote in message news:1147719046.287057.257170@j55g2000cwa.googlegroups.com...
> 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,
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.

Ron,

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

jonah