Check this link to David McRitchie's web page on the subject.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"harriet" wrote in message
...
I'm trying to do a mail merge to a label document. I have 10 separate
names
to put in 10 separate labels. I insert the merge field. When it goes to
merge
& print the doc, it only merges the 1st name under the title it isn't
grabbing all the names to put in each of the labels.

Thank you in advance for your help!

Harriet