Label Merge in Microsoft 2003 with Excel Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SongbirdKLN - 04 May 2005 22:24 GMT

My data is in Excel and I am merging into labels. The first page is great.
I lose one record when I go to the next page and subsequent pages. HELP.

Reply to this Message

Stuart Troy - 04 May 2005 22:42 GMT

This occurs because you have the "NEXT RECORD" field at the very start of
the page, AND at the very end of the page.

Simply remove the "NEXT RECORD" field from the start, and you won't lose a
record.

You may need to turn field codes on to see the "NEXT RECORD" field in your
document.
Click Tools | Options | View | Check the Field Codes box.

Happy merging.
Stuart
Sydney, Australia

Reply to this Message

Graham Mayor - 05 May 2005 05:42 GMT

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
The first label should not have a NEXT record field.

Signature

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

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

> My data is in Excel and I am merging into labels. The first page is
> great. I lose one record when I go to the next page and subsequent
> pages. HELP.

Reply to this Message