none
DoCmd (acces) cannot send email after update RRS feed

  • 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?
    Friday, February 16, 2018 4:02 PM

Answers

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

    THX for all your suggestions

    • Marked as answer by DMDanny Monday, February 26, 2018 1:28 PM
    Monday, February 26, 2018 1:28 PM

All replies

  • 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?
    • Proposed as answer by Terry Xu - MSFT Thursday, February 22, 2018 6:23 AM
    Friday, February 16, 2018 4:09 PM
  • 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 MSDNFSF@microsoft.com.

    Thursday, February 22, 2018 6:27 AM
  • 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.
    Friday, February 23, 2018 1:26 PM
  • 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

    Friday, February 23, 2018 1:49 PM
  • 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


    Friday, February 23, 2018 1:54 PM
  • I solved the problem myself by installing all Outlook updates up to and including 16.0.4654.1000.

    THX for all your suggestions

    • Marked as answer by DMDanny Monday, February 26, 2018 1:28 PM
    Monday, February 26, 2018 1:28 PM
  • 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

    Monday, February 26, 2018 1:30 PM