 |
 | 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 / January 2005Mail merge from excel file to produce labels for mass mailing
I am trying to create labels from an excel spreadsheet containing names and addresses. I use the mail merge wizard in word. I should end up with 3 and a half sheets of labels (30 labels to a sheet). Instead, I'm ending up with 125 as it is putting one record on each page! Help! Hi Jeanie, I don't have an answer for your questions, but I have the post right below yours. Could you take a look at it and provide me suggestions. Basically I'm trying to print label in Word 2003 from Excel 2003 and when I follow the mail merge instructions, but when I select my excel file I get black labels on the screen. Thanks for any help. Michael > I am trying to create labels from an excel spreadsheet containing names and > addresses. I use the mail merge wizard in word. I should end up with 3 and a > half sheets of labels (30 labels to a sheet). Instead, I'm ending up with > 125 as it is putting one record on each page! > > Help! Hi Jeanie, Make sure your columns contain headers and that you have specified the Print Area of the data you wish to be captured in the merge. Otherwise Excel exports all empty cells and you end up with numerous blank pages of labels. > I am trying to create labels from an excel spreadsheet containing names and > addresses. I use the mail merge wizard in word. I should end up with 3 and a > half sheets of labels (30 labels to a sheet). Instead, I'm ending up with > 125 as it is putting one record on each page! > > Help! 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  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP >I am trying to create labels from an excel spreadsheet containing names and > addresses. I use the mail merge wizard in word. I should end up with 3 [quoted text clipped - 3 lines] > > Help! Thank you! My wizard steps don't mention the propagate icon and I have never used it/seen it before! I have my labels. Jeanie > See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's > website at [quoted text clipped - 8 lines] > > > > Help! |
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.