 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2006Labels
Everytime I try to mail merge labels from a data source, whether Excel or Word database, the lables merge incorrectly. I.E. I get the first address in the list in the first label of the page and the second on a NEW page of labels with all other labels on the page blank. I troubleshooted to no end and can successfully merge letters and envelopes but not labels What version of Word are you using? Before you run the merge do you see the merge fields on all your labels on the page? It may be that you haven't replicated the fields to the other labels on the page. Andrea Jones > Everytime I try to mail merge labels from a data source, whether Excel or > Word database, the lables merge incorrectly. I.E. I get the first address in > the list in the first label of the page and the second on a NEW page of > labels with all other labels on the page blank. I troubleshooted to no end > and can successfully merge letters and envelopes but not labels I am using 2003 and no I do not see the merge fields on the labels, do they have to be pulled into every label manually? > What version of Word are you using? Before you run the merge do you see the > merge fields on all your labels on the page? It may be that you haven't [quoted text clipped - 7 lines] > > labels with all other labels on the page blank. I troubleshooted to no end > > and can successfully merge letters and envelopes but not labels There is a Propogate Labels button on the mail merge toolbar that I suggest that you activate by selecting Toolbars from the View menu and then check the Mail Merge item.  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP >I am using 2003 and no I do not see the merge fields on the labels, do they > have to be pulled into every label manually? [quoted text clipped - 14 lines] >> > end >> > and can successfully merge letters and envelopes but not labels okay I really hate it when I troubleshoot for hours and find out it was a click of the mouse! Thanks! > What version of Word are you using? Before you run the merge do you see the > merge fields on all your labels on the page? It may be that you haven't [quoted text clipped - 7 lines] > > labels with all other labels on the page blank. I troubleshooted to no end > > and can successfully merge letters and envelopes but not labels See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_labels_with_word_xp.htm SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Everytime I try to mail merge labels from a data source, whether Excel or > Word database, the lables merge incorrectly. I.E. I get the first address [quoted text clipped - 3 lines] > end > and can successfully merge letters and envelopes but not labels I'll check out the article, and once again it is always a relief to find out it is the program, not you, I hope 2007 has better merge capabilities > See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's > website at [quoted text clipped - 8 lines] > > end > > and can successfully merge letters and envelopes but not labels It is not the program. It is merely that you have not followed all the steps in the wizard correctly. The link to my web page posted by Doug shows in simple diagrams how to do it either with the wizard or the toolbar. Mail merge in Word really is simple, but it does have some quirks. I can't see it changing much in 2007! Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I'll check out the article, and once again it is always a relief to > find out it is the program, not you, I hope 2007 has better merge [quoted text clipped - 20 lines] >>> troubleshooted to no end >>> and can successfully merge letters and envelopes but not labels |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.