How to work with the Outlook E-mail Security Update in an Access database (263084)


The information in this article applies to:

  • Microsoft Access 2000
  • Microsoft Access 2002
  • Microsoft Office Access 2003
  • Microsoft Outlook 2000
  • Microsoft Outlook 2002
  • Microsoft Office Outlook 2003
This article was previously published under Q263084
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you use the SendObject macro action or the SendObject Microsoft Visual Basic for Applications (VBA) method, and the EditMessage argument is 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 several seconds, and then you can click Yes. If you click Yes, the e-mail message is sent. If you click No, the message is not sent, and then you may receive one of the following error messages.

Error message that is received with the SendObject macro action

Microsoft Access can't send a message for the reason stated in the preceding alert.

Resolve that problem, and then send the message again.

Error message that is received with the SendObject VBA method

Run-time error '2293':

Microsoft Access can't send a message for the reason stated in the preceding alert.

CAUSE

When you apply the Microsoft Outlook E-mail Security Update, the Outlook E-mail Security Update provides additional levels of protection against malicious e-mail messages. The Outlook E-mail Security Update changes the way that attachments are handled by Outlook and the way that Outlook can be controlled programmatically.

Note The Outlook E-mail Security Update is included with Microsoft Outlook 2002 and Microsoft Office Outlook 2003.

WORKAROUND

To work around this problem, you can customize the behavior of the Outlook E-mail Security Update. You can customize the behavior only if you are running Outlook in a Microsoft Exchange Server environment, and your e-mail messages are delivered to a server-based mailbox.

Note If your mail is delivered to a Personal Folders (.pst) file, you cannot configure the settings for the update.

For more information about this security update, click the following article number to view the article in the Microsoft Knowledge Base:

262631 Information about the Outlook E-mail Security Update



You cannot bypass or avoid this security feature if you are using code with the Outlook Object Model, Collaboration Data Objects 1.21, and Simple MAPI. To avoid the security prompts, you can use the following methods which do not utilize the components that are previously mentioned:
  • Administer settings from the server by using the steps in the following Microsoft Knowledge Base article:

    290499 Administrator information about e-mail security features


    290500 Description of the developer-related e-mail security features in Outlook 2002

  • If you do not have control over client environments, then you can use CDO for Windows (CDOSYS) that is installed with Windows 2000 and Windows XP.
    For more information, click the following article number to view the article in the Microsoft Knowledge Base:

    286431 How to send HTML formatted mail using CDO for Windows 2000 and a remote SMTP service


    286430 How to send HTML formatted mail using CDO for Windows 2000 and the Local Pickup directory

  • You can use Extended MAPI to send mail and access data. However, the language and the API are more complex than using Visual Basic with the Outlook Object Model.
  • Create a COM add-in for Outlook
    For more information, click the following article number to view the article in the Microsoft Knowledge Base:

    316983 A sample COM add-in that uses the Visual Basic 6.0 add-in template


    240768 How to programmatically reference a COM add-in

MORE INFORMATION

Steps to reproduce the problem

  1. Apply the Outlook E-mail Security Update on a computer that is running Microsoft Access 2000 and Outlook 2000.
  2. Open the Northwind.mdb sample database.
  3. In the Database window, click Macros, and then click New.
  4. Create a new macro that has the following actions:
       Macro name   Action
   -----------------------
   TestSend     SendObject


   TestSend action arguments
   -------------------------------
   SendObject
   Object Type: Report
   Object Name: Catalog
   Output Format: Rich Text Format
   To: <email address>
   Edit Message: No
  5. On the File menu, click Save.
  6. On the Run menu, click Run.

    Notice that you receive the following message that is mentioned in the "Symptoms" section: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".If you click Yes, your e-mail message is sent. If you click No, you may receive the following error message:
    Microsoft Access can't send a message for the reason stated in the preceding alert.

    Resolve that problem, and then send the message again.
  7. Close the macro.
  8. On the Insert menu, click Module.
  9. In the new module, add the following code:
    Sub VBATestSend()
  DoCmd.SendObject acReport, "Catalog", "RichTextFormat(*.rtf)", _
  "<email address>", "", "", "This is a test.", "", False, ""
End Sub
  10. In the Immediate window, add the following code, and then press ENTER:
    VBATestSend
    Notice that you receive the following message that is mentioned in the "Symptoms" section: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".If you click Yes, your e-mail message is sent. If you click No, you receive the following error message:
    Run-time error '2293':

    Microsoft Access can't send a message for the reason stated in the preceding alert.

REFERENCES

For more information about how other Microsoft Office products may be affected by the Outlook E-mail Security Update, click the following article numbers to view the articles in the Microsoft Knowledge Base:

290499 Administrator information about e-mail security features

262634 Description of known issues with the Outlook E-mail Security Update in Outlook 2000

262618 Known issues with the Outlook E-mail Security Update

For additional information about uninstalling the update, visit the following Microsoft Web site:

http://office.microsoft.com/assistance/2000/Out2ksecFAQ.aspx

Modification Type:MinorLast Reviewed:3/15/2006
Keywords:kbtshoot kbSecurity kbProgramming kberrmsg kbinterop kbprb KB263084 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.