|
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" 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 |
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" 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 |
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" 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 -- 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" 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 -- 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" 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 -- 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" 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 -- 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 |
| All times are GMT +1. The time now is 08:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com