Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation, send email or red flag if cell value exceeded
How to write a macro so that if a value in a cell is exceeded, the excel window will flash or turn to red? In a financial excel spread sheet, a manager has to keep track on the total money every day. If the money is exceed a certain value he has to take actions. How to make this automation by flashing or turn red or even better send email? Thanks Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation, send email or red flag if cell value exceeded
Ron de Bruin is pretty much the master of this stuff!!
http://www.rondebruin.nl/mail/change.htm Oh, and this is worth a look too: http://www.contextmagic.com/express-clickyes/ I don't think you will be sending multiple emails, but if you do, run that small utility. Try sending multiple emails without it, and try sending multiple emails with it...it's magic.... Regards, Ryan--- -- RyGuy "Daniel" wrote: How to write a macro so that if a value in a cell is exceeded, the excel window will flash or turn to red? In a financial excel spread sheet, a manager has to keep track on the total money every day. If the money is exceed a certain value he has to take actions. How to make this automation by flashing or turn red or even better send email? Thanks Daniel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation, send email or red flag if cell value exceeded
Or use Outlook 2007 or CDO or redemption
See http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryguy7272" wrote in message ... Ron de Bruin is pretty much the master of this stuff!! http://www.rondebruin.nl/mail/change.htm Oh, and this is worth a look too: http://www.contextmagic.com/express-clickyes/ I don't think you will be sending multiple emails, but if you do, run that small utility. Try sending multiple emails without it, and try sending multiple emails with it...it's magic.... Regards, Ryan--- -- RyGuy "Daniel" wrote: How to write a macro so that if a value in a cell is exceeded, the excel window will flash or turn to red? In a financial excel spread sheet, a manager has to keep track on the total money every day. If the money is exceed a certain value he has to take actions. How to make this automation by flashing or turn red or even better send email? Thanks Daniel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation, send email or red flag if cell value exceeded
Thanks Ron
I tried this by copying and paste to sheet tab/view code but I have to run macro manually. How to be automation when the value of a cell exceed exp 200 "Ron de Bruin" wrote: Or use Outlook 2007 or CDO or redemption See http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryguy7272" wrote in message ... Ron de Bruin is pretty much the master of this stuff!! http://www.rondebruin.nl/mail/change.htm Oh, and this is worth a look too: http://www.contextmagic.com/express-clickyes/ I don't think you will be sending multiple emails, but if you do, run that small utility. Try sending multiple emails without it, and try sending multiple emails with it...it's magic.... Regards, Ryan--- -- RyGuy "Daniel" wrote: How to write a macro so that if a value in a cell is exceeded, the excel window will flash or turn to red? In a financial excel spread sheet, a manager has to keep track on the total money every day. If the money is exceed a certain value he has to take actions. How to make this automation by flashing or turn red or even better send email? Thanks Daniel |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation, send email or red flag if cell value exceeded
See
http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Daniel" wrote in message ... Thanks Ron I tried this by copying and paste to sheet tab/view code but I have to run macro manually. How to be automation when the value of a cell exceed exp 200 "Ron de Bruin" wrote: Or use Outlook 2007 or CDO or redemption See http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryguy7272" wrote in message ... Ron de Bruin is pretty much the master of this stuff!! http://www.rondebruin.nl/mail/change.htm Oh, and this is worth a look too: http://www.contextmagic.com/express-clickyes/ I don't think you will be sending multiple emails, but if you do, run that small utility. Try sending multiple emails without it, and try sending multiple emails with it...it's magic.... Regards, Ryan--- -- RyGuy "Daniel" wrote: How to write a macro so that if a value in a cell is exceeded, the excel window will flash or turn to red? In a financial excel spread sheet, a manager has to keep track on the total money every day. If the money is exceed a certain value he has to take actions. How to make this automation by flashing or turn red or even better send email? Thanks Daniel |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation, send email or red flag if cell value exceeded
Hi Ron
Why I have to hit yes to allow to send email message. How to make it automatically? Daniel "Ron de Bruin" wrote: See http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Daniel" wrote in message ... Thanks Ron I tried this by copying and paste to sheet tab/view code but I have to run macro manually. How to be automation when the value of a cell exceed exp 200 "Ron de Bruin" wrote: Or use Outlook 2007 or CDO or redemption See http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryguy7272" wrote in message ... Ron de Bruin is pretty much the master of this stuff!! http://www.rondebruin.nl/mail/change.htm Oh, and this is worth a look too: http://www.contextmagic.com/express-clickyes/ I don't think you will be sending multiple emails, but if you do, run that small utility. Try sending multiple emails without it, and try sending multiple emails with it...it's magic.... Regards, Ryan--- -- RyGuy "Daniel" wrote: How to write a macro so that if a value in a cell is exceeded, the excel window will flash or turn to red? In a financial excel spread sheet, a manager has to keep track on the total money every day. If the money is exceed a certain value he has to take actions. How to make this automation by flashing or turn red or even better send email? Thanks Daniel |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation, send email or red flag if cell value exceeded
See
http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Daniel" wrote in message ... Hi Ron Why I have to hit yes to allow to send email message. How to make it automatically? Daniel "Ron de Bruin" wrote: See http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Daniel" wrote in message ... Thanks Ron I tried this by copying and paste to sheet tab/view code but I have to run macro manually. How to be automation when the value of a cell exceed exp 200 "Ron de Bruin" wrote: Or use Outlook 2007 or CDO or redemption See http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryguy7272" wrote in message ... Ron de Bruin is pretty much the master of this stuff!! http://www.rondebruin.nl/mail/change.htm Oh, and this is worth a look too: http://www.contextmagic.com/express-clickyes/ I don't think you will be sending multiple emails, but if you do, run that small utility. Try sending multiple emails without it, and try sending multiple emails with it...it's magic.... Regards, Ryan--- -- RyGuy "Daniel" wrote: How to write a macro so that if a value in a cell is exceeded, the excel window will flash or turn to red? In a financial excel spread sheet, a manager has to keep track on the total money every day. If the money is exceed a certain value he has to take actions. How to make this automation by flashing or turn red or even better send email? Thanks Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send email based on cell value | Excel Programming | |||
Ecel - every cell clicked on wants to send email | Excel Discussion (Misc queries) | |||
Send Email depending on Cell Value | Excel Programming | |||
Send Email When Cell Value Changes | Excel Programming | |||
send email from cell contents | Excel Discussion (Misc queries) |