WD2000: Merge Results Blank Using Header File with ODBC Data Source

ID: Q212104

The information in this article applies to:

Microsoft Word 2000

SYMPTOMS

You may receive blank results during a mail merge when the mail merge document uses a header file and you have attached a database source file using ODBC.

For each record merged, you may receive the following message, where "x" is the record number:

One or more data fields in record x were truncated.

WORKAROUND

To work around this problem, use one of the following methods:

Method 1: Use ODBC to Attach Your Data Source

Do not attach a separate header file when you use ODBC to attach your data file. Instead, add your mail merge field names to your data file.

Method 2: Use DDE to Attach Your Data Source

When you attach your data source to your mail merge main document, follow these steps:

In the Mail Merge Helper (on the Tools menu, click Mail Merge), click Get Data and then click Open Data Source.

In the Open Data Source dialog box, click to select your data source, select the Select method check box, and then click Open.

In the Confirm Data Source dialog box, click to select the appropriate data source via DDE and click OK.

MORE INFORMATION

For additional information about creating a mail merge data source, click the article number below to view the article in the Microsoft Knowledge Base:

Q212322 WD2000: How to Design and Set Up Mail Merge Data

Additional query words:

Keywords : kbdta kbmerge wd2000
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb