Email on error event

[cavscout]

I have a Autoexec macro that runs thru an update process several times a day automatically and when complete sends an email to me that tells me all is well.

I'm tired of deleteing these confimations now and would like to change the macro to only send the email on error or when the macro does not complete running.

I'm hoping it is a simple as using the condition field in the macro but haven't seen much about conditions in macros.

Would this be better suited to a module?

I'm using Access 97.

Thank you in advance.

 

[chenn]

This would be better suited in a module. This way you could add an error handler to send an email incase of a program error and also send an email incase certain criteria are met.