Send Object cancel crash

[CData]

Greetings, invoking the Outlook client on the PC to open works fine - as does sending the email. But if one changes their mind and closes the outlook window without sending the email (using the X in the upper right) then Access has a spinning wheel and eventually gives up and closes.... Is there a way to avoid / manage this scenario?

[HansV]

In my experience, error 2501 occurs when the user cancels the email; an error handler can take care of that. Here is a very simple example:

Code: Select all

Sub Test()
    On Error GoTo ErrHandler
    DoCmd.SendObject ObjectType:=acSendNoObject, Subject:="Test", MessageText:="Hello World", EditMessage:=True
    Exit Sub
ErrHandler:
    If Err = 2501 Then
        ' Message canceled; ignore
    Else
        MsgBox Err.Description, vbExclamation
    End If
End Sub

[CData]

hmmm so just trapping & ignoring will stop Access from the spin & crash.... interesting... thanks will give it a try.....