Microsoft KB Archive/888697

= You may receive the &quot;Word was unable to open the data source&quot; error message when you try to mail merge to Word by using an Access parameter query in Microsoft Access =

Article ID: 888697

Article Last Modified on 3/30/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition
 * Microsoft Office Word 2007
 * Microsoft Office Word 2003
 * Microsoft Word 2002 Standard Edition

-





INTRODUCTION
When you try to mail merge to Microsoft Word 2002 or a later version by using a parameter querty from Microsoft Access 2002 or a later version of Access, you may receive the following error message:

Word was unable to open the data source.



MORE INFORMATION
You receive the error message that is mention in the &quot;Introduction&quot; section because you are trying to mail merge by using Microsoft Open Database Connectivity (ODBC).

The following steps demonstrate the mail merge process. The following steps use a new Word document. However, you can revise the steps to use an existing Word mail merge document. To mail merge with a parameter query, we recommend that you use dynamic data exchange (DDE).

The following steps are general steps that tell you how to mail merge with a parameter query.

Word 2002 or Word 2003
 Start Word. On the Tools menu, click Options. On the General tab, click to select the Confirm conversion at Open check box, and then click OK.

Note This lets you select the appropriate mail merge method. Create a new blank document. On the Tools menu, point to Letters and Mailings, and then click Mail Merge. In the Mail Merge pane, click one of the following document types under Select document type:  Letters</li> E-mail messages</li> Envelopes</li> Labels</li> Directory</li></ul>

Note The following steps use the Letters document type as an example.</li> In the Mail Merge pane, click Next Starting document.

Note The active document becomes the main document.</li> In the Mail Merge pane, click Next Select recipients.</li> In the Mail Merge pane, click Browse under Use an existing list.</li> In the Select Data Source dialog box, click your Access database in the Look in box, and then click Open.</li> In the Confirm Data Source dialog box, click MS Access Databases via DDE (*.mdb, *.mde), and then click OK.</li> In the Microsoft Access dialog box, click the Queries tab, and then click your query.</li> In the Mail Merge Recipients dialog box, click OK.</li> In the Mail Merge pane, click Next Write your letter.</li> Write your letter, and then add your query data.</li> In the Mail Merge pane, click Next Preview your letters.

Note You are supposed to see a new document appear with the data from your query.</li> In the Mail Merge pane, click Next Complete the merge to continue with the mail merge.</li></ol>

Word 2007
<ol> <li>Start Word.</li> <li>Click the Microsoft Office Button, and then click Word Options.</li> <li>Click the Advanced tab, click to select the Confirm file format conversion on open check box in the General area, and then click OK.

Note This option enables you to select the appropriate mail merge method.</li> <li>Create a new blank document.</li> <li>On the Mailings tab, click Start Mail Merge, and then click Step by Step Mail Merge Wizard.</li> <li></li> <li>In the Mail Merge pane, click one of the following document types under Select document type: <ul> <li>Letters</li> <li>E-mail messages</li> <li>Envelopes</li> <li>Labels</li> <li>Directory</li></ul>

Note The following steps use the Letters document type as an example.</li> <li>In the Mail Merge pane, click Next Starting document.

Note The active document becomes the main document.</li> <li>In the Mail Merge pane, click Next Select recipients.</li> <li>In the Mail Merge pane, click Browse under Use an existing list.</li> <li>In the Select Data Source dialog box, click your Access 2007 database file (.accdb), and then click Open.</li> <li>In the Confirm Data Source dialog box, click the Show all check box, click MS Access Databases via DDE (*.mdb, *.mde), and then click OK.</li> <li>In the Microsoft Access dialog box, click the Queries tab, and then click your query.</li> <li>In the Mail Merge Recipients dialog box, click OK.</li> <li>In the Mail Merge pane, click Next Write your letter.</li> <li>Write your letter, and then add your query data.</li> <li>In the Mail Merge pane, click Next Preview your letters.

Note You expect to see a new document appear with the data from your query.</li> <li>In the Mail Merge pane, click Next Complete the merge to continue with the mail merge operation.</li></ol>

<div class="references_section">