Send email if an error message popup when running macro

N

Nancy

I have a database which runs a macro from the Task Scheduler each night. The
macro builds tables and creates export files that are uploaded to our web
site each night. It is very important that I am immediately notified if an
error message pops up (visual basic or macro error) during the running of the
macro. I've tried adding an "OnError" line which would run a macro to send
me an email but I cannot get it right.

Suggestions will be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending an email from a Macro Problem 3
How to Avoid getting email message box when Access macro sends rep 1
Soltion for You can't exit MS Access error message 4
Error When Using TransferText in a Macro 1
stop error message when opening a non existant file in a macro 1
Macro to send email with multiple attachment 0
Set a macro to send an email 2
Email Excel Cell Range using Macro 2

Top