ACC97: "A Program Is Trying to Send..." Message with SendObject Macro or Method

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: 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.

With the SendObject Macro Action

With the SendObject VBA Method

You have applied the Outlook E-mail Security Update.

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

Steps to Reproduce the Behavior

1. Install Microsoft Access 97 and Microsoft Outlook 98.
2. Apply the Outlook 98 E-mail Security Update.
3. Open the sample database Northwind.mdb.
4. In the Database window, click Macros, and then click New.
5. 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
   					

6. On the File menu, click Save.
7. On the Run menu, click Run. Note that you receive the first message, "A program is trying to automatically...", that is described in the "Symptoms" section of this article. If you click Yes, your e-mail message is sent. If you click No, you see the 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.
8. Close the macro, and then on the Insert menu, click Module.
9. In the new module, type the following code:

   Sub VBATestSend()
     DoCmd.SendObject acReport, "Catalog", "RichTextFormat(*.rtf)", _
     "<email address>", "", "", "This is a test", "", False, ""
   End Sub
   					

10. In the Debug window, type the following line, and then press ENTER:

    VBATestSend
    					

    Note that you receive the message, "A program is trying to automatically...", that is described in the "Symptoms" section of this article. 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.

For more information about how other Microsoft Office products may be affected by the Outlook E-mail Security Update, please see one of the following articles in the Microsoft Knowledge Base, depending on which version of Outlook you have: If you have questions about uninstalling the update, see the "Outlook Email Security Update - Frequently Asked Questions" page at the following Microsoft Web site: