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

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

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.



"Ragdyer" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>

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

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

harriet wrote:
> 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.
>
>
>
> "Ragdyer" wrote:
>
>
>>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" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>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
>>
>>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote:

> Word MVP Graham Mayor has some label instructions on his web site. Maybe
> they'll help you:
>
> http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
>
> harriet wrote:
> > 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.
> >
> >
> >
> > "Ragdyer" wrote:
> >
> >
> >>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" <[email protected]> wrote in message
> >>news:[email protected]...
> >>
> >>>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
> >>
> >>
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

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" wrote:

> Word MVP Graham Mayor has some label instructions on his web site. Maybe
> they'll help you:
>
> http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
>
> harriet wrote:
> > 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.
> >
> >
> >
> > "Ragdyer" wrote:
> >
> >
> >>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" <[email protected]> wrote in message
> >>news:[email protected]...
> >>
> >>>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
> >>
> >>
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

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

harriet wrote:
> 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" wrote:
>
>
>>Word MVP Graham Mayor has some label instructions on his web site. Maybe
>>they'll help you:
>>
>> http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
>>
>>harriet wrote:
>>
>>>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.
>>>
>>>
>>>
>>>"Ragdyer" wrote:
>>>
>>>
>>>
>>>>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" <[email protected]> wrote in message
>>>>news:[email protected]...
>>>>
>>>>
>>>>>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
>>>>
>>>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html