Problem sending email from form in Access 2007 vb (DoCmd.SendObject)
Posted on 2008-11-17
We've upgraded from Access 2003 to 2007 and I'm having problems with a vb function sending emails from an Access form. Everything works fine - it opens the email box in Outlook, when I click on "send email" in Outlook it sends it immediately, BUT it doesn't close the email window. All commands in the window are disabled, if I wait about 20 seconds it closes itself, or I can click on the close button.
This never used to happen in 2003, when I sent the email the email window would close.
What am I doing wrong?