WD98: Word Ignores First Record in Excel Data Source (188666)
The information in this article applies to:
- Microsoft Word 98 Macintosh Edition
This article was previously published under Q188666 SYMPTOMS
When you perform a mail merge using a Microsoft Excel data source that does
not contain a header row, and you attach a separate header document,
Microsoft Word ignores the first row of data from the Excel data file. As a
result, if the first row in the Excel worksheet contains a data record,
this record is not merged.
CAUSE
This problem occurs when you are performing a mail merge via a DDE
connection with a Microsoft Excel Worksheet as your data.
WORKAROUND
To work around this problem, use one of the following methods.
Method 1
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 2
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 10/4/2002 |
|---|
| Keywords: | kbbug kbmerge KB188666 |
|---|
|