Emailing from access using SendObject

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.

 

Question Info


Last updated February 12, 2018 Views 407 Applies to:
Are you creating an e-mail that needs to be edited? If not, change the True at the end to False. and it will just send the mail. 
Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Yes, it needs to be edited. 

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

The Edit step pretty much takes over. It's like opening a form in Dialog mode. The code is stopped until the email is sent. The other email programs are not tied to Access the way Outlook is. Nor do they have security that stops any program from sending an Outlook email without the user's manual permission.
Bill Mosca
ThatllDoIT.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I see. So how can I work around it? How can I use Access to populate the TO, CC, BCC and SUBJECT lines, then leave the Outlook message screen open for them to type their message and not be "locked out" of Access while doing so? Remembering that some users still are on other email programs, so the code would have to consider that...

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Karen

I don't know of a work-around for that. Access VBA is designed that way. Maybe calling the SendObject when the form closes would be better. I don't know. It depends on the workflow.

Bill Mosca
ThatllDoIT.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Thank you anyway. I have started a new thread because I want to approach this from a different angle, and felt a new thread was the proper way to do it.          

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.