Microsoft KB Archive/188666

= WD98: Word Ignores First Record in Excel Data Source =

Article ID: 188666

Article Last Modified on 10/4/2002

-

APPLIES TO


 * Microsoft Word 98 for Macintosh

-



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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: excel xl datafile dde dynamic exchange converter field missing one initial

Keywords: kbbug kbmerge kbpending KB188666

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.