Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-19-2009, 10:11 AM
CathyLewis CathyLewis is offline Mail merge is duplicating labels Windows 7 Mail merge is duplicating labels Office 2007
Novice
Mail merge is duplicating labels
 
Join Date: May 2009
Posts: 2
CathyLewis is on a distinguished road
Default Mail merge is duplicating labels

I'm having an issue with mail merge. I am importing an excel file to create mailing labels. There are 83 names on the list and I should end up with 3-4 pages of labels. Instead, the program is duplicating names and I end up with 83 pages of labels. Can anyone offer a solution to this?
Reply With Quote
  #2  
Old 05-19-2009, 12:24 PM
CathyLewis CathyLewis is offline Mail merge is duplicating labels Windows 7 Mail merge is duplicating labels Office 2007
Novice
Mail merge is duplicating labels
 
Join Date: May 2009
Posts: 2
CathyLewis is on a distinguished road
Default

Additional information: I am working on a MAC, OS 10, using MS Word 2008 12.1.7. The problem I am having is not because of the MAC format. Another person using PC format has had the same result.
Reply With Quote
  #3  
Old 05-19-2009, 06:43 PM
zyzzyva57 zyzzyva57 is offline Mail merge is duplicating labels Windows 7 32bit Mail merge is duplicating labels Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

You might check for duplicates to see what what Word is "seeing" just to make sure

Failing this, I would start over to make sure I have not checked or unchecked something, and I have selected the correct labels--tantamount many times in troubleshooting to see if something is plugged in -- If we do something over and over we can get careless on the obvious
Attached Images
File Type: jpg 3.jpg (31.7 KB, 23 views)
Reply With Quote
  #4  
Old 02-22-2011, 08:32 AM
karen h karen h is offline Mail merge is duplicating labels Windows XP Mail merge is duplicating labels Office 2003
Novice
 
Join Date: Feb 2011
Posts: 8
karen h is on a distinguished road
Default

This works with a PC but I have not used a MAC. Place a "next record" after all the fields at the end of each label.

Similar to this:

first name last name
address
city state zip next record

HOWEVER

do NOT put this code on the last label on the page or it will skip a record
Reply With Quote
  #5  
Old 05-26-2014, 11:54 PM
Sallyw Sallyw is offline Mail merge is duplicating labels Mac OS X Mail merge is duplicating labels Office for Mac 2011
Novice
 
Join Date: May 2014
Posts: 1
Sallyw is on a distinguished road
Default I found a work around

I was having this kind of problem with mail merge using a Mac.

Every so often a record was repeated. I deleted the next record tag at the point of failure and reinserted it.... and that fixed it.

I can only assume that the next record tag had been damaged. The document had been heavily edited.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
word 2003 mail merge labels? JoeGrapes Mail Merge 0 04-20-2009 12:43 PM
Mail merge is duplicating labels Mail Merge If rules bordercollie10 Mail Merge 2 02-10-2009 12:43 PM
Mail Merge Mohanss82 Mail Merge 0 01-21-2009 12:29 PM
Mail Merge Query kangabanga Mail Merge 0 09-25-2008 04:07 AM
Merge mail not working jdpowell@brazoriainet.com Mail Merge 1 07-25-2008 07:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft