Errors sending email from Access 2003, when dbase window is hidden

B

Byzantine

I'm getting an error running the following code, if the user cancels the
operation during the routine, when the database window is Access hidden:

DoCmd.SendObject acSendNoObject, To:="(e-mail address removed)", Subject:="Re: Test
Message", MessageText:="", EditMessage:=True

The error message I get is:

ErrorNo. -2147467259 User cancelled the operation.

The error only occurs when I've got the dbase window hidden.

I've tried to handle this error number but the system just hangs when
returning to Access.

Has anyone got any ideas? Please note I'm not a spammer!

Any help is much 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

Top