Visual Basic DoCmd.SendObject error
We are currently on exchange server 2003 using outlook 2007. I am testing exchange server upgrade to 2007. When I run VB code DoCmd.SendObject I recieve the runtime error 2293, Microsoft office access can't send this email message. This only happens on the new exchange server 2007. When I move it back to the old exchange, no error messages occur. Is there a spam setting, filter, preferences that could be causing this error message on exchange server 2007?
December 22nd, 2009 8:52pm
I believe you're executing the script from MS Access, not from Outlook - please confirm? Because, "When I run VB code DoCmd.SendObject I recieve the runtime error 2293, Microsoft office access can't send this email message" this eror code specified error related to MS Access.Why we get like this? When you run the SendObject macro action or the SendObject Visual Basic for Applications method with the EditMessage argument set to No, you may receive the following message: "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?"If this is unexpected, it may be a virus and you should choose "No". The Yes button in the dialog box is disabled for a few seconds, and then you are able to click Yes. If you click Yes, the e-mail message is sent. If you click No, the message is not sent, and you then see one of the following error messages. In detail: If you try to execute a script and if it tries to execute Outlook object model object, you will get a security prompt from 'Outlook Object Model guard'. This is in-turn from Outlook object model to prevent unauthorized user or malicious code to send SPAM mails to others. This is a security feature.Best practice: Make sure you have the latest service packs in client(outlook) and server(exchange server 2007).Try this out.DeVa, M.S., {MSFT}
Free Windows Admin Tool Kit Click here and download it now
December 23rd, 2009 3:25am