mail merge- & data source - only taking 1st name in the list

[Guest]

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

 

[Ragdyer]

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

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

 

[Guest]

Thank you for the site which is pretty good. I've done what he says. I'm
still having the probelm where when you merge it only graps the first name in
the column & ignores the rest. I've made it the first sheet, I have a
header, I've set a print range on the list - so when the source is accepted
it identifies the print range as my source, but it won't take the whole
column.

 

[Debra Dalgleish]

Word MVP Graham Mayor has some label instructions on his web site. Maybe
they'll help you:

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

 

[Guest]

Hi Ms. Dalgleish,
I stumbled upon it myself. I was on the MVP website & the other website the
other person who was trying to help me. (which I appreciate you both)

I didn't see this anywhere -but I seem to skip a lot of things -
Anyways, in the merge toolbar is a button for propogate labels. I clicked
on that & then the rest of the list appeared on the labels.

It is very frustrating when you dig for stuff & it isn't written anywhere.
By chance have you seen this "propogating labels" referenced any where?

thanks again,
harriet

 

[Guest]

Hi Ms. Daldleish,
I just went to the website you referenced Mr. Mayor. He does say something
about the propogate button - that was the first one I saw that said anything
about that button.

thank you very much,

this is the 2nd time you helped me - thank you!! harriet

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that you found what you needed.