On error send email

[cavscout]

I have a macro that runs thru an update process 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.

I'm using Access 97.

Thank you in advance.