http://www.dbforums.com/microsoft-access/1636135-runtime-error-2293-a.html

Points to

http://www.dbforums.com/6288349-post6.html

Which is

Here’s what I found with the docmd.sendobject command. User XXXX is using Outlook 2003. Outlook 2003 has changed their security for sending emails with an attachment. For vba code, the docmd.sendobject command cannot be utilized with the Edit Message set to True and the “TO” left blank. A “TO” must be supplied and the Edit Message must be set to “False” in the vba code (at least to my knowledge so far).
Once these parameters are supplied in the vba command and a user clicks on the button to send the attachment, a message box will appear stating to the effect: “A program is trying to send an attachment on your behalf. Do you want to allow this?” and a progress bar appears. Once the progress bar has reached the end, the Yes box is enabled where the user must click Yes in order to complete the email.

For example, this (where me!EmailTo = the email address):

DoCmd.SendObject acReport, stDocName, “RichTextFormat(*.rtf)”, Me!EmailTo, “”, “”, “Some message”, “”, True, “”

will give the error 2293

whereas this:

DoCmd.SendObject acReport, stDocName, “RichTextFormat(*.rtf)”, Me!EmailTo, “”, “”, “Some Message”, “”, False, “”

does not.

Oh, and this issue seems to be Outlook service pack related.

http://en.wikipedia.org/wiki/Michael_Vincent_%28magician%29

Michael Vincent

http://www.michaelvincentproductions.com/