How do I prevent mail merge from skipping records?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donna - 03 Aug 2005 21:09 GMT

I'm merging records from Excel into a Word template. The template is a
modified label format that prints 10 cards per page. During merging, every
eleventh record throughout the entire database has been skipped.

I use the same data to merge with an Address Label Template #5660 - No
records are skipped.

Reply to this Message

Doug Robbins - 03 Aug 2005 22:05 GMT

Remove the <<Next Record>> field from the first label in the mailmerge main
document.

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'm merging records from Excel into a Word template. The template is a
> modified label format that prints 10 cards per page. During merging,
[quoted text clipped - 3 lines]
> I use the same data to merge with an Address Label Template #5660 - No
> records are skipped.

Reply to this Message

Donna - 03 Aug 2005 22:25 GMT

Not working. When I remove <<Next Record>>, it prints that first record
twice. Now, instead of skipping every eleventh record, it skips every tenth.

> Remove the <<Next Record>> field from the first label in the mailmerge main
> document.
[quoted text clipped - 6 lines]
> > I use the same data to merge with an Address Label Template #5660 - No
> > records are skipped.

Reply to this Message

Graham Mayor - 04 Aug 2005 05:26 GMT

See where what you are doing differs from
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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Not working. When I remove <<Next Record>>, it prints that first
> record twice. Now, instead of skipping every eleventh record, it
[quoted text clipped - 17 lines]
>>> I use the same data to merge with an Address Label Template #5660 -
>>> No records are skipped.

Reply to this Message

Doug Robbins - 04 Aug 2005 05:28 GMT

The Next Record field must be the first field in all of the labels except
for the first label on the sheet in which there must not be a Next Record
field.

If after removing the Next Record field from the first label, that record
prints twice, it indicates to me that you have the Next Record field AFTER
the other merge fields in the labels, NOT BEFORE them.

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

> Not working. When I remove <<Next Record>>, it prints that first record
> twice. Now, instead of skipping every eleventh record, it skips every
[quoted text clipped - 11 lines]
>> > I use the same data to merge with an Address Label Template #5660 - No
>> > records are skipped.

Reply to this Message

Donna - 04 Aug 2005 14:55 GMT

Doug, I knew I was doing something wrong. This WORKED. THANKS.

> The Next Record field must be the first field in all of the labels except
> for the first label on the sheet in which there must not be a Next Record
[quoted text clipped - 19 lines]
> >> > I use the same data to merge with an Address Label Template #5660 - No
> >> > records are skipped.

Reply to this Message

Rate this thread: