Microsoft Knowledge Base Email Alertz
All KB/RSS Links  |  Hot Kb!  |  New Kb!  |  Scott Cate  |  FAQ / KB  |  Web Hosting  |  Unsubscribe  

KBAlertz.com: Describes the Word was unable to open the data source error message. You may receive this error message when you mail merge to Word by using an Access parameter query.

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.
Click here to create a
FREE account
Already have an account?
[Click here to Login]

Search KbAlertz

Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]






Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

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

View products that this article applies to.
Article ID:888697
Last Review:March 30, 2007
Revision:2.1
On This Page

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.

Back to the top

MORE INFORMATION

You receive the error message that is mention in the "Introduction" 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.

Back to the top

Word 2002 or Word 2003

1.Start Word.
2. On the Tools menu, click Options.
3. 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.
4. Create a new blank document.
5. On the Tools menu, point to Letters and Mailings, and then click Mail Merge.
6.In the Mail Merge pane, click one of the following document types under Select document type:
•Letters
•E-mail messages
•Envelopes
•Labels
•Directory
Note The following steps use the Letters document type as an example.
7. In the Mail Merge pane, click Next Starting document.

Note The active document becomes the main document.
8. In the Mail Merge pane, click Next Select recipients.
9. In the Mail Merge pane, click Browse under Use an existing list.
10. In the Select Data Source dialog box, click your Access database in the Look in box, and then click Open.
11. In the Confirm Data Source dialog box, click MS Access Databases via DDE (*.mdb, *.mde), and then click OK.
12. In the Microsoft Access dialog box, click the Queries tab, and then click your query.
13.In the Mail Merge Recipients dialog box, click OK.
14. In the Mail Merge pane, click Next Write your letter.
15.Write your letter, and then add your query data.
16. 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.
17. In the Mail Merge pane, click Next Complete the merge to continue with the mail merge.

Back to the top

Word 2007

1.Start Word.
2.Click the Microsoft Office Button, and then click Word Options.
3.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.
4. Create a new blank document.
5.On the Mailings tab, click Start Mail Merge, and then click Step by Step Mail Merge Wizard.
6.
7.In the Mail Merge pane, click one of the following document types under Select document type:
•Letters
•E-mail messages
•Envelopes
•Labels
•Directory
Note The following steps use the Letters document type as an example.
8. In the Mail Merge pane, click Next Starting document.

Note The active document becomes the main document.
9. In the Mail Merge pane, click Next Select recipients.
10. In the Mail Merge pane, click Browse under Use an existing list.
11. In the Select Data Source dialog box, click your Access 2007 database file (.accdb), and then click Open.
12. 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.
13. In the Microsoft Access dialog box, click the Queries tab, and then click your query.
14.In the Mail Merge Recipients dialog box, click OK.
15. In the Mail Merge pane, click Next Write your letter.
16.Write your letter, and then add your query data.
17. 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.
18. In the Mail Merge pane, click Next Complete the merge to continue with the mail merge operation.

Back to the top

REFERENCES

For additional information about using an Access connection to Word, click the following article numbers to view the articles in the Microsoft Knowledge Base:
813989 (http://kbalertz.com/Feedback.aspx?kbNumber=813989/) You receive a Word could not re-establish a DDE connection error message in Word 2003
211193 (http://kbalertz.com/Feedback.aspx?kbNumber=211193/) Queries not available when using Access database
211353 (http://kbalertz.com/Feedback.aspx?kbNumber=211353/) Mail merge stops responding when you use an Access parameter query
214183 (http://kbalertz.com/Feedback.aspx?kbNumber=214183/) How to use mail merge with an Access parameter query in Word 2000

Back to the top

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

Back to the top

Keywords: 
kbmerge kberrmsg kbdatabase kbhowto KB888697

Back to the top

    

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Be the first to leave feedback, to help others about this knowledge base article.

(Optional) Name
(Optional) Public URL Or Email
Comments
No HTML -- Text Only Please

 



Copyright © 2002-2007 KBALERTZ.COM.  All Rights Reserved. Terms / Privacy. Discount ASP.NET Hosting