none
Error Message 'Database cannot send this email' RRS feed

  • Question

  • Hi,

    I have vba code to send an email using sendobject.

    It works fine on my computer, using Access2010 and Outlook2010. I copied the database to a machine with Access 2013 and Outlook 2013 for another user.

    Now the email fails with the message 'the database cannot send this email'. 

    Any suggestions where to look.  Could it be a change in syntax needed due to the version change?

    thanks for any insights.


    MS - Teach me to fish

    Thursday, August 4, 2016 3:32 PM

Answers

  • Thanks for the posts. I am afraid I must have forgot to checl the alert box and just saw the replies now.

    I resolved the issue by changing the SendObject edit option to true.  Once i did that all worked fine.

    So it would appear that the securtiy settings on the second system are tighter and have a restriction that emails cannot be sent automatically.  The user has to intervene and hit the send button.

    While not an ideal resolution, it appeased the users.  They only have to hit send and the email is already formatted.

    To answer some of the questions:  No, the outlook window did not open at all.  I did check the references and they were good. 


    MS - Teach me to fish

    • Proposed as answer by David_JunFeng Thursday, August 11, 2016 2:01 PM
    • Marked as answer by David_JunFeng Tuesday, August 16, 2016 2:00 PM
    Tuesday, August 9, 2016 8:52 PM

All replies

  • Hi. Do you even see Outlook open up? Is the 2013 machine set up to use Outlook as the default?
    Thursday, August 4, 2016 3:36 PM
  • As theDBguy stated, have you validated that Outlook is configured and functional and has security set to allow interaction with it.

    Also, Did you verify that your db compiles without any errors on the new PC?  Checked references?

    Can you post the procedure in question.


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

    Thursday, August 4, 2016 5:04 PM
  • Hi lismeta,

    According to your description, you could follow theDBguy suggestion, you could refer to this link about How to change your default e-mail client in Outlook.

    In addition you could refer to below links:
    http://support.microsoft.com/?id=884998

    http://support.microsoft.com/?id=263084

    http://support.microsoft.com/?id=834008


    Thanks for your understanding.

    Friday, August 5, 2016 3:15 AM
  • Thanks for the posts. I am afraid I must have forgot to checl the alert box and just saw the replies now.

    I resolved the issue by changing the SendObject edit option to true.  Once i did that all worked fine.

    So it would appear that the securtiy settings on the second system are tighter and have a restriction that emails cannot be sent automatically.  The user has to intervene and hit the send button.

    While not an ideal resolution, it appeased the users.  They only have to hit send and the email is already formatted.

    To answer some of the questions:  No, the outlook window did not open at all.  I did check the references and they were good. 


    MS - Teach me to fish

    • Proposed as answer by David_JunFeng Thursday, August 11, 2016 2:01 PM
    • Marked as answer by David_JunFeng Tuesday, August 16, 2016 2:00 PM
    Tuesday, August 9, 2016 8:52 PM
  • Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.
    Tuesday, August 9, 2016 9:22 PM