MS Access Run-time error 2293 - Microsoft Access can't send this e-mail message

Question

Hello,

I have a piece of code in MS Access to send an email through Outlook 2016 (locally on the same computer). It still works fine just a week ago. But today I get this error: Run-time error 2293: Microsoft Access can't send this e-mail message. I did not change anything on Access or Outlook except I notice that there is an security update on MS Office 2016 on 11/9/2021 (exactly is the day it still works fine). I have checked everything but no clues. Would that be a security thing change that avoid Access to send through Outlook? Please help!

Here is how I send the email:

canada_add = "xxxxx"

strSubject = "xxxxx"
strBody = "Hello, xxxxx"
blnDisplayMsg = True

DoCmd.SendObject acSendReport, "invoice-can", acFormatPDF, canada_add, , , strSubject, strBody, blnDisplayMsg

Thanks

Answer 1

It does seem like an issue caused by Windows Update. I have tried to put the code on another computer which has not been used for a while (i.e. not updated yet) and it works again. Though I cannot verify which updated version has the issue.

Answer 2

My default email client is set to Outlook and it is working fine. Any idea?

If something that used to work fine all of a sudden stops working, you could check if there were any recent updates/patches that may have broken the system.

Answer 3

My default email client is set to Outlook and it is working fine. Any idea?

Answer 4

Hi. The SendObject method uses the default email client. Make sure it's still set to Outlook. Then, manually open Outlook and verify it still works.