duplicate lables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike_mor - 02 Feb 2005 21:37 GMT

I am getting duplicate lables when i run a mail merge in Word 2003. I am
using an excel spreadsheet as my data source, it does not have any dupes. I
can take the same .xls file home and run the merge on my home PC with Office
2000 and it works fine. This happens with all mail merges, not just one
specific file.

Any help would be very much appreciated...

Thanks,
Michael

Reply to this Message

Doug Robbins - 02 Feb 2005 23:46 GMT

What happens if you take the mailmerge main document home as well? Almost
certainly the problem is caused by missing <<Next Record>> fields in the
mail merge main document. They are required before the first merge field in
ALL of the labels on the sheet OTHER THAN the first label.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am getting duplicate lables when i run a mail merge in Word 2003. I am
> using an excel spreadsheet as my data source, it does not have any dupes.
[quoted text clipped - 8 lines]
> Thanks,
> Michael

Reply to this Message

Graham Mayor - 03 Feb 2005 06:10 GMT

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am getting duplicate lables when i run a mail merge in Word 2003.
> I am using an excel spreadsheet as my data source, it does not have
[quoted text clipped - 6 lines]
> Thanks,
> Michael

Reply to this Message