mail merge is repeating names from excel document, why?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeannie - 31 Aug 2005 15:40 GMT

When I do a mail merge to print labels, I use an existing excel document.
What happens is that the names repeat over and over again throughout the
pages. What am I doing wrong?

Reply to this Message

Doug Robbins - 31 Aug 2005 19:26 GMT

In the mailmerge main document, there should be a <<Next Record>> field
before the first mergefield in each of the labels on the sheet EXCEPT for
the first label.

See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham
Mayor's website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

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 do a mail merge to print labels, I use an existing excel document.
> What happens is that the names repeat over and over again throughout the
> pages. What am I doing wrong?

Reply to this Message

Rate this thread: