Merge not functioning properly...

[TKYSpirit]

Merge is only showing/printing 10 of 17 documents listed in the data file. I
have used the 'check merge for errors' feature and the query feature to try
and get it to print the other 7 records in the data file. Have explored web
to find an answer to no avail. Any help out there? I have had this problem on
2 competely separate merge jobs. All the data has come from the data source
and can be displayed under the 'edit' button in the merge dialog box. All
data records can also be displayed in an excel worksheet, manipulated, saved,
etc. When the merge is ready to 'merge', I set it to print to a new document:
Only 10 of the 17 records print. There does not seem to be any particular
rhyme or reason to what it is or is not selecting. Thanks for any help
offered.

 

[Peter Jamieson]

is it always the same 10 records that print OK?

Are they the first 10?

Are there any hidden columns or rows in your spreadsheet?

Are there any characters such as single-quotes or double-quotes in the last
record that prints, or the one after it?

Can you edit/copy, edit/paste your spreadsheet into a new Word document and
use that successfully as the merge data source?

Peter Jamieson