duplicates in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerim79 - 22 Nov 2006 22:24 GMT

I am running Word 97 and Excel 97. The excel sheet is just a list of
names and addresses. The word document is for labels. There are no
duplicates in the excel sheet. However, when I do the mail merge, it
duplicates the last entry on the page. So the last entry on the page is
also the first entry at the top of the next page. It isn't tied to any
particular name and address as I have tried rearranging those. It's no
terribly big deal, as the duplicates only 8 total.

Reply to this Message

Doug Robbins - Word MVP - 23 Nov 2006 04:40 GMT

In the mail merge main document, there needs to be a NEXT RECORD field
before the first merge field in all of the labels except the first label.

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 running Word 97 and Excel 97. The excel sheet is just a list of
> names and addresses. The word document is for labels. There are no
[quoted text clipped - 3 lines]
> particular name and address as I have tried rearranging those. It's no
> terribly big deal, as the duplicates only 8 total.

Reply to this Message