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?

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" wrote in message
...
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?

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.

"Doug Robbins" wrote:

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" wrote in message
...
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?

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_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


lmcwill wrote:
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.

"Doug Robbins" wrote:

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" wrote in message
...
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?