duplicates in mail merge

J

Jerim79

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.
 
D

Doug Robbins - Word MVP

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.

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top