Not all records are merging to table in document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Louise - 18 Feb 2004 19:16 GMT

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?

Reply to this Message

Peter Jamieson - 19 Feb 2004 07:25 GMT

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/

> 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?

Reply to this Message