Why is my mail merge skipping every third record?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

plm - 18 Jul 2006 19:53 GMT

When I merge an excel database into a name badge template it skips every
third record. I believe I do have "next record" in the correct place. Out
of 362 records only 242 are being merged. I am using Windows XP Professional.

Reply to this Message

Doug Robbins - Word MVP - 19 Jul 2006 04:46 GMT

Where do you have the <<Next Record>> fields? There should be one BEFORE
the first merge field on each name badge in the mail merge main document
EXCEPT for the first name badge.

You should NOT have the <<Next Record>> field after the merge fields on each
name badge ESPECIALLY after the merge fields on the last name badge on the
mail merge main document as Word indexes automatically when it goes to the
next sheet and if you also have a <<Next Record>> field at that point, Word
will index by 2.

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

> When I merge an excel database into a name badge template it skips every
> third record. I believe I do have "next record" in the correct place.
> Out
> of 362 records only 242 are being merged. I am using Windows XP
> Professional.

Reply to this Message

Rate this thread: