Home |
Search |
Today's Posts |
#1
|
|||
|
|||
creating labels, not addresses, from an Excel file
I have excel files that I would like to extract information from and put it
onto labels. I've tried to use the Mail Merge function in Word to do this, but have had no luck. Right now when I preview or print labels I get a sheet full of labels with "Next Record" printed on each label. The label in the upper left corner is blank. Also, is there a way to use only certain columns of an Excel sheet as data to be included in the label? FYI, I am using MS Office 2003 versions of Word and Excel. |
#2
|
|||
|
|||
See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm which should
address all your questions. The megre will use whatever fields (columns) are available in the data file. They don't have to be addresses. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org some_guy79 wrote: I have excel files that I would like to extract information from and put it onto labels. I've tried to use the Mail Merge function in Word to do this, but have had no luck. Right now when I preview or print labels I get a sheet full of labels with "Next Record" printed on each label. The label in the upper left corner is blank. Also, is there a way to use only certain columns of an Excel sheet as data to be included in the label? FYI, I am using MS Office 2003 versions of Word and Excel. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating address labels in word from excel data - date changes | Microsoft Word Help | |||
Need help with Word Mail Merge Wizard creating labels from excel . | Mailmerge | |||
How do I display Avery type labels as I am creating for file fold. | Microsoft Word Help | |||
How can I print Avery labels from excel file? | Microsoft Word Help | |||
Mail merge from excel file to produce labels for mass mailing | Mailmerge |