When I use sendobject to send email (VBA code in MS Access), Access locks up until I Send the message in Outlook, After I send the email, I can then go back to Access. Is there a way to free up Access after I execute the docmd.sendobject command but before I hit the Send button in Outlook? Some of our users use Outlook, some use other email programs. The other email programs (Mozilla Thunderbird and Lotus Notes) do not cause this "lock up." Here is my code:
Public Function Email2()
On Local Error GoTo Err
If IsNull(Screen.ActiveForm.txtEmail) Then
MsgBox "An email address is required before using this feature", , "FYI"
Else
DoCmd.SendObject , , , Screen.ActiveForm.txtEmail, , , [Forms]![matters]![MatterName], , True
End If
Err:
If Err.Number = 2293 Then MsgBox "Please open email program before requesting email functions", , "LP"
GoTo Out
If Err.Number = 2501 Then GoTo Out
MsgBox Err.Number & ", " & Err.Description
Out:
End Function
Thank you so much for any help.