DoCmd (acces) cannot send email after update

Question

Sending email from acces (DoCmd send object) does not work after the last update of Windows 10 build 1709
Is there a solution for this?

Answer 1

Hi, One solution might be to revert the last update, if possible. Otherwise, were you getting any error messages? If so, what does it say?

Answer 2

Hello DMDany,

Could reverting update work for you? What's your code and what error did you get?

Would you please clarify your scenario more detailed?

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

Our Office version (Access + Outlook) is 16.0.4549.1000 32-bits.
We use a button in MS Access to send a report.
The button contains the command:
Dim stDocName As String
     stDocName = "R_derdenrekeningMAIL"
     DoCmd.SendObject acReport, stDocName

Then we get an error message that the report can not be sent from Access.
The error code is 2293.

Answer 4

Have you tried outputting the report to PDF and then use Outlook automation instead?

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 5

So you are getting a message like

"Microsoft Access can't send this e-mail message.@Before attempting to send an e-mail message from Microsoft Access, resolve the problem identified in the previous message, or configure your computer to send and receive e-mail messages.@@1@@@1"

Do you get another message prior to that one?  What is it?

Is Outlook configured and functional on the PC?

Does your VBA project compile without errors?

Can you open that report without any issues?

Can you use SendObject to send an email without any objects?

Similarly, can you use SendObject to send an email with another object?

Are you not applying any other input variables?  To, subject, message?

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 6

I solved the problem myself by installing all Outlook updates up to and including 16.0.4654.1000.

THX for all your suggestions

Answer 7

Good to hear all is back as it should be.

Very odd that it would work, then stop, yet an update would make thing work again.  Makes me think your previous update had a bug?!

Thank you for posting back with your solution as it may well help someone else out facing the same issue.

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net