Office 2003 mail merge with random repeating labels

jdaniel001 · 10-20-2008, 10:45 AM

I am using MS Office 2003 and when I complete the mail merge wizard, I get the sheets of labels printing out with random duplicate labels. The mail merge is large (200 labels). Any ideas?

**gistek** · 10-20-2008, 11:36 AM

did you check for duplicate records in your source table?

Access has a query wizard to do this. If you have Access, but are using an excel table, link the table into an empty database and run the duplicates query.

---

Excel is a little more difficult because you have to sort on the item you think is duplicated.

Make a copy of the file.

If you need to match data in 2 or more fields (say, F-name & L-name), use CONCATENATE to create a field with both parts in one field. =CONCATENATE(A1,B1) will create F-nameLname in the box.

Copy the entire column and paste-values-only to change the formula to its answer.

I also suggest removing all spaces (incase one record has an extra space somewhere). Highlight the column you created, use <Ctrl-F> to open the find window, click the replace tab, enter one space in the find box and leave the replace box empty. Then click the replace all button.

Sort the table using the new column as your sort-on, then use Summary to group any identical entries in that column. It'll give you several options, pick the Count option as the output.

Then look for any counts greater than 1.

10-20-2008, 10:45 AM	#1 (permalink)
jdaniel001 Registered User Join Date: Oct 2008 Posts: 2 OS: xp	Office 2003 mail merge with random repeating labels I am using MS Office 2003 and when I complete the mail merge wizard, I get the sheets of labels printing out with random duplicate labels. The mail merge is large (200 labels). Any ideas?

10-20-2008, 11:36 AM	#2 (permalink)
gistek Folding Along Join Date: May 2007 Location: PA, USA Posts: 1,912 OS: Bobbi=xp, sp3 Muse=Vista Home Premium	Re: Office 2003 mail merge with random repeating labels did you check for duplicate records in your source table? Access has a query wizard to do this. If you have Access, but are using an excel table, link the table into an empty database and run the duplicates query. --- Excel is a little more difficult because you have to sort on the item you think is duplicated. Make a copy of the file. If you need to match data in 2 or more fields (say, F-name & L-name), use CONCATENATE to create a field with both parts in one field. =CONCATENATE(A1,B1) will create F-nameLname in the box. Copy the entire column and paste-values-only to change the formula to its answer. I also suggest removing all spaces (incase one record has an extra space somewhere). Highlight the column you created, use <Ctrl-F> to open the find window, click the replace tab, enter one space in the find box and leave the replace box empty. Then click the replace all button. Sort the table using the new column as your sort-on, then use Summary to group any identical entries in that column. It'll give you several options, pick the Count option as the output. Then look for any counts greater than 1. __________________ I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team