What type of merge? (Form Letter, Catalog/Directory?)
Do you have any <<Next Record>> fields in your mail merge main document
(i.e. { NEXT } fields) ? Or NEXTIF/SKIPIF fields?
Does your Excel sheet have any double quotes " in the data (not necessarily
in the fields you are actually using in the merge).
Please let us know which version of Word/Excel you are using, and which
method (DE/ODBC/OLEDB/Converter) you are using to get the data from Excel.
--
Peter Jamieson - Word MVP
Word MVP web site
http://word.mvps.org/
Louise said:
I have a Word document that contains a table. In the table, I have merged
a list from Excel (name and account number) into the first two columns of
the table. When I merge the data, I am missing some of the records (the
table contains the first record, the second record, and then skips to every
other one). There are no blank lines on the table, just missing records.
What could be wrong?