No records are displayed when you merge data with Microsoft Word (301595)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2002
  • Microsoft Word 2002
This article was previously published under Q301595
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you try to merge data from a Microsoft Access query with Microsoft Word, Microsoft Word displays one of the following error messages:
Word could not merge the main document with the data source because the data records were empty or no data records matched your query options.

-or-

No recipients match the filter criteria you specified. Check the recipient list to make sure it is not empty or change your filter criteria to include more recipients.
However, when you run the query in Microsoft Access, the correct records are displayed.

CAUSE

By default, Word is configured to use the Jet.OLEDB provider to retrieve records from an Access database. If the Access query contains the wild card characters "*" or "?" in the criteria, the wild card characters will be ignored by the Jet.OLEDB provider and no matching records will be returned. The Jet.OLEDB provider is based on ANSI 92 syntax, which supports the wild card characters "%" and "_", not the wild card characters "*" and "?".

For example, Like "B*" will not work correctly, but Like "B%" will work correctly.

RESOLUTION

You can use the following options to allow Word to retrieve the correct records.
  • Change the criteria from "*" to "%" or from "?" to "_".

    NOTE: If the query is being used by Access, make a copy of the query, change to "%" or "_" in the copy, and then use this copy for merging with Word.
  • Modify the database to use ANSI 92 syntax. You can do so by clicking Options on the Tools menu, and then clicking the Tables/Queries tab. On this tab, click to select the SQL Server Compatible Syntax (ANSI 92) check box, and then modify all queries to use "%" instead of "*" or "_" instead of "?".

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. Create a new query that is based on the Customers table.
  3. In the Criteria row, under the Company Name field, add Like "A*".
  4. Save and then close the query.
  5. In the Database window, click the query that you just created.
  6. On the Tools menu, point to Office Links, and then click Merge It with Microsoft Word.
  7. On the first page of the Microsoft Word Mail Merge Wizard, click Create a new document and then link the data to it, and then click OK. Note that Microsoft Word opens.
  8. On the Mail Merge toolbar, click Insert Merge Fields. Select the field or fields to insert into the mail merge document, and then click Close.
  9. On the Mail Merge toolbar, click Merge to New Document, and then click OK. Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
NOTE: If you use the Microsoft Word Mail Merge Wizard to complete the mail merge (using the query created above) you also receive an error. The error received is as follows:
No recipients match the filter criteria you specified. Check the recipient list to make sure it is not empty or change your filter criteria to include more recipients.

REFERENCES

For additional information about other Mail Merge questions, click the following article number to view the article in the Microsoft Knowledge Base:

290408 WD2002: Frequently Asked Questions About Mail Merge

Modification Type:MinorLast Reviewed:6/8/2004
Keywords:kbImport kberrmsg kbmerge kbprb KB301595
©2004 Microsoft Corporation. All rights reserved.