Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Email When Cell Value Changes
Hi
Try http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Email When Cell Value Changes
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Email When Cell Value Changes
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 wrote in message oups.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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Email When Cell Value Changes
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Email When Cell Value Changes
Ron,
It's okay, i just figured it out! Thank you for your help! jonah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to send automatic email when cell value changes in excel | Excel Worksheet Functions | |||
Ecel - every cell clicked on wants to send email | Excel Discussion (Misc queries) | |||
how do i can send a information of cell automaticaly via email? | New Users to Excel | |||
send email from cell contents | Excel Discussion (Misc queries) | |||
How do I build a feature into a cell that would send an email rem. | Excel Worksheet Functions |