Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail 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! |
#2
|
|||
|
|||
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 "Jeanie" wrote: 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! |
#3
|
|||
|
|||
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. "Jeanie" wrote: 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! |
#4
|
|||
|
|||
See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Please 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 "Jeanie" wrote in message news 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! |
#5
|
|||
|
|||
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 "Doug Robbins" wrote: See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Please 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 "Jeanie" wrote in message news 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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
How do I print mailing labels with mail merge? | Mailmerge | |||
Printing Labels using Mail Merge with data from Excel | Mailmerge | |||
Why can't I use Mail Merge Wizard with Avery 2160 labels?. | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |