WD: Word Ignores First Record in Excel Data Source

WORKAROUND

In Microsoft Windows, this problem does not occur when you use the Microsoft Excel Worksheet via an Excel Converter method or ODBC method.

This problem also does not occur when you use other types of data sources.

To work around this problem, use any of the following methods.

Method 1

1. In the Mail Merge Helper, when you click Open Data Source (Get Data under Data Source), click Confirm Conversions (Word 6.x) or Select Method (Word 7.x).
2. Select the file you want to Open and then click OK or click Open.
3. When the Confirm Data Source dialog box appears, select Microsoft Excel Worksheet via Converter (*.xls, *.xlw).
4. Click OK.

Method 2

Insert a row above the first record in your Excel data file. Word will ignore this first row and merge all of your records.

Method 3

Instead of using a Header document, insert a row above the first record in your Excel data file and type the header field names in this row.