merging from excel to word dropping record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lindylou - 19 Mar 2008 17:27 GMT

I have a data base in excel 2003 and am merging to labels in word 2003. One
record is dropping off at the page break ... I'm merging 30 labels per sheet
-- records 1-30 appear on the first sheet, but the second sheet starts with
record 32 (31 disappears), same with every page break one label/record is
missing. Anyone know why and how to fix it??

Reply to this Message

Doug Robbins - Word MVP - 19 Mar 2008 20:36 GMT

You probably have the <<Next Record>> fields in the wrong place, or one too
many of them. The correct place is BEFORE the first mergefield in all of
the labels on the mail merge main document EXCEPT for the first label. You
can get away with it being located after the last mergefield in all of the
labels as long as you do NOT have one after the last mergefield in the LAST
label on the sheet.

Word automatically indexes to the next record at the page break.

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 data base in excel 2003 and am merging to labels in word 2003.
>One
[quoted text clipped - 4 lines]
> record 32 (31 disappears), same with every page break one label/record is
> missing. Anyone know why and how to fix it??

Reply to this Message

Rate this thread: