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

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

"mail merge" mail wrote in message
...
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

See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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


mail merge wrote:
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