Why does the mail merge print a whole sheet of the same label?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kipandsheril - 05 Oct 2007 15:24 GMT

I have created a custom label, actually an A4 business card, for use as name
tags at a conference. These are printed in portrait - the writing going
sideways - with additional designs added. When I do the mail merge, the final
merged document has a whole sheet of the same name - a sheet of record 1,
then a sheet of record 11, etc.

I have tried the mail merge two different ways: In Word using an Excel data
source and in Outlook after importing my contacts from the Excel data. Both
ways I come up with the same problem. PLEASE HELP!!

Reply to this Message

Peter Jamieson - 05 Oct 2007 18:11 GMT

Do you definitely have one { NEXT } field (use Alt-F9 to check) at the
beginning of each label cell except the first?

(It sounds as if you must, but please check anyway).

Which version of Word?

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I have created a custom label, actually an A4 business card, for use as
>name
[quoted text clipped - 9 lines]
> Both
> ways I come up with the same problem. PLEASE HELP!!

Reply to this Message

Graham Mayor - 06 Oct 2007 06:27 GMT

See http://www.gmayor.com/mailmerge_from_outlook.htm
and http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

As Peter suggests it seems as though you have this setup as a form letter
merge and have not inserted the NEXT record fields which a label merge would
correctly place for you.

Signature

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

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

> I have created a custom label, actually an A4 business card, for use
> as name tags at a conference. These are printed in portrait - the
[quoted text clipped - 5 lines]
> Excel data source and in Outlook after importing my contacts from the
> Excel data. Both ways I come up with the same problem. PLEASE HELP!!

Reply to this Message