Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jerim79 Jerim79 is offline
external usenet poster
 
Posts: 1
Default duplicates in mail merge

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.

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default duplicates in mail merge

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

"Jerim79" wrote in message
ups.com...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 09:33 PM
how do i eliminate duplicates in word 2003 mail merge? Vicky Mailmerge 3 September 15th 06 04:43 AM
Heavy Mail Merge Application Atul Mailmerge 1 August 17th 06 02:37 PM
many duplicates when i try to mail merge labels mr_malkovich Mailmerge 0 January 6th 06 06:25 AM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 04:11 AM


All times are GMT +1. The time now is 11:38 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"