Some Access database queries are unavailable as data sources in the Mail Merge Wizard

Article translations Article translations
Article ID: 320476 - View products that this article applies to.
This article was previously published under Q320476
Expand all | Collapse all

SYMPTOMS

When you try to use a Microsoft Access query as the data source in a Word mail merge operation, some of the queries in the Access database may be unavailable as data sources in the Mail Merge Wizard.

WORKAROUND

To work around this problem, confirm that Word uses Dynamic Data Exchange (DDE) when you attach the Access database to the mail merge document. To do this, follow these steps:
  1. Open a new blank document.
  2. On the Tools menu, click Options, and then click the General tab.
  3. Click to select the Confirm conversion at Open check box, and then click OK.
  4. On the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard.
  5. Under Select document type, click the type that you want, and then click Next: Starting document.
  6. Under Select starting document, click the document that you want to use, and then click Next: Select recipients.
  7. Under Select recipients, click Use an existing list, and then click Browse under Use an existing list.
  8. Locate and open the folder that contains the Access database that you want to use as your data source, click the database, and then click Open.
  9. In the Confirm Data Source dialog box, click MS Access Databases via DDE (*.mdb, *.mde), and then click OK.
  10. In the Microsoft Access dialog box, click the Queries tab, click the query that you want to use, and then click OK.
    NOTE: All the queries in the Access database are available.

REFERENCES

For more information about troubleshooting DDE connections in Word, click the following article numbers to view the articles in the Microsoft Knowledge Base:
291445 Error Message: Word could not re-establish a DDE connection to Microsoft Access
286847 First mail merge recipient is duplicated when you connect to the data source through the DDE method

Properties

Article ID: 320476 - Last Review: January 7, 2006 - Revision: 1.2
APPLIES TO
  • Microsoft Word 2002 Standard Edition
Keywords: 
kbprb KB320476

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com