I created a excel date base for my labels (I also tried word and text file).
When I use mail merge to generate my labels, it gave me "Next Record" in each
cell rather than my vender's name that I want. Please help me on this.
Lili Han
Peter Jamieson - 14 Feb 2006 19:15 GMT
Word doesn't know what columns in the Excel sheet you want in your labels,
so you have to insert a "Merge field" for each column you want to appear. If
you are using Word 2002 or 2003, the thing to do is insert the fields you
want in the first label, then use the Propagate Labels option (or button) to
copy those fields to all the other labels without disturbing the Next Record
fields. It's often easier to work with mailmerges if you use Tools|Customize
to enable the Mailmerge toolbar where all the main MailMerge functions are
available.
Peter Jamieson
>I created a excel date base for my labels (I also tried word and text
>file).
[quoted text clipped - 3 lines]
>
> Lili Han
Graham Mayor - 15 Feb 2006 07:04 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 created a excel date base for my labels (I also tried word and text
> file). When I use mail merge to generate my labels, it gave me "Next
> Record" in each cell rather than my vender's name that I want. Please
> help me on this.
>
> Lili Han