Email from Access - handle cancel error

[Ed Robichaud]

I'm temporarily stumped on how to handle/suppress an error (2501) if a user
cancels sending an email. I'm using DoCmd.SendObject to trigger an Outlook
send window, which works OK, but if the msg is cancelled (not sent) then a
VB runtime error msg appears (#2501) that I would like to either hide or
deal with.
-Ed

[King Ron]

Do you have an OnError clause in the calling module?

Is it triggered?

If you don't have an OnError clause, see the VB help for OnError

King Ron of Chi

[Keith]

"Ed Robichaud" <ed*********@wdn.com> wrote:

I'm temporarily stumped on how to handle/suppress an error (2501) if a
user cancels sending an email. I'm using DoCmd.SendObject to trigger
an Outlook send window, which works OK, but if the msg is cancelled
(not sent) then a VB runtime error msg appears (#2501) that I would
like to either hide or deal with.
-Ed

Your first line of code should be an 'On Error GoTo' statement. You can
then handle the error thus:

If Err.Number = 2501 Then
Exit Sub
Else
Beep
MsgBox Err.Number & ", " & Err.Description
End If

Don't forget the 'Exit Sub' before the error handler too.

Keith.
www.keithwilby.com

[Ed Robichaud]

Thanks. I had all that, but foolishly had it sequenced after the
SendObject.
-Ed

"Keith" <ke*********@AwayWithYerCrap.com> wrote in message
news:Xn***********************@10.15.188.42...

"Ed Robichaud" <ed*********@wdn.com> wrote:

I'm temporarily stumped on how to handle/suppress an error (2501) if a
user cancels sending an email. I'm using DoCmd.SendObject to trigger
an Outlook send window, which works OK, but if the msg is cancelled
(not sent) then a VB runtime error msg appears (#2501) that I would
like to either hide or deal with.
-Ed

Your first line of code should be an 'On Error GoTo' statement. You can
then handle the error thus:

If Err.Number = 2501 Then
Exit Sub
Else
Beep
MsgBox Err.Number & ", " & Err.Description
End If

Don't forget the 'Exit Sub' before the error handler too.

Keith.
www.keithwilby.com