Error 2501 when Email Cancelled

[firebirdta84]

I have a form with a button that, when pressed, will open MS Outlook and attach a query from the database in XLS format. It works perfectly, but if I click the button and then decide I don't want to send the email and close out of the email, I get Run-time error 2501: The SendObject action was cancelled. Here's the code for the button:

DoCmd.SendObject acSendQuery, "qry_Master", acFormatXLS, "joe123@yahoo.com", , , "Daily Update"

Any help would be appreciated!

 

[PHV]

Simply use an error handler routine ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886