mail merge drops records at new page

[lmcwill]

I have a 300-record, 4-field Excel file merging into a Word 2 column by 5 (or
7) label document. It's not really labels but the format is what I need.
When the merge moves to a new page, it skips a record in the Excel file.
Thus, page one merges records 1-10 (or 1-14) and page two starts with record
12 (or 16). Each page "loses" a record.

Any thoughts on why this is and how to fix it?

 

[Doug Robbins]

Sounds like you have a <<Next Record field in the first label where it is
not required.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[lmcwill]

Taking the {Next Record} field out of the first label (at the end of the last
line) results in merging the Excel record twice. And the merge still misses
a record at the new page. Thanks, though.

 

[Graham Mayor]

Next record field should be at the *start* of each label except the first.
Word puts it there automatically!
See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>