Label merge Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shooting Star - 26 May 2005 15:33 GMT

I am merging an data from excel into word label format. The contact field
from the previous record is duplicated in the next label if that label has
not contact information. Exampe - President is the contact field for one
label and then it is printed on the next label even though that field is
blank for that particular record. How do I prevent this from happening?

Reply to this Message

Graham Mayor - 26 May 2005 18:54 GMT

This shouldn't happen if the merge is set up correctly - 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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am merging an data from excel into word label format. The contact
> field from the previous record is duplicated in the next label if
> that label has not contact information. Exampe - President is the
> contact field for one label and then it is printed on the next
> label even though that field is blank for that particular record.
> How do I prevent this from happening?

Reply to this Message

Doug Robbins - 26 May 2005 19:04 GMT

In the mailmerge main document, do you have a <<NextRecord>> field before
the first mergefield in all of the labels except the first?

If you are using the Address Block, don't. Just insert the mergefields that
you require in the configuration that you want.

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 am merging an data from excel into word label format. The contact field
> from the previous record is duplicated in the next label if that label has
> not contact information. Exampe - President is the contact field for one
> label and then it is printed on the next label even though that field is
> blank for that particular record. How do I prevent this from happening?

Reply to this Message