Macro run failure notification to email

[jpf1281]

I am trying to figure out a way to have a macro send me an email if the macro fails or hangs for a certain amount of time and I am really not sure how to do this, or if it can be done. Any help would be appreciated.

[Grovkillen]

Sure you can. My take on this is to build a watchdog which is looking for a heartbeat from the scripts that it's monitoring. The scripts themselves will make sure that this heartbeat is updated within a known time interval. If the watchdog isn't detecting a heartbeat it will wait x number of cycles and if the heartbeat is still not detected it will act.