mail merge drops records at new page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lmcwill - 09 Sep 2005 22:17 GMT

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?

Reply to this Message

Doug Robbins - 09 Sep 2005 22:26 GMT

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

Signature

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

>I have a 300-record, 4-field Excel file merging into a Word 2 column by 5
>(or
[quoted text clipped - 5 lines]
>
> Any thoughts on why this is and how to fix it?

Reply to this Message

lmcwill - 09 Sep 2005 22:55 GMT

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.

> Sounds like you have a <<Next Record field in the first label where it is
> not required.
[quoted text clipped - 8 lines]
> >
> > Any thoughts on why this is and how to fix it?

Reply to this Message

Graham Mayor - 10 Sep 2005 06:39 GMT

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

Signature

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

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

> 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
[quoted text clipped - 19 lines]
>>>
>>> Any thoughts on why this is and how to fix it?

Reply to this Message