ieslop.blogg.se

If you use a Named area you have access to all your fields and can ignore this paragraph. Though material in Word appears that you can have all kinds of fields, The three lines in your address must represent 3 cells in a row in yourĮxcel file, and should begin with the first in Column A. Named Ranges are known and available to the entire workbook. Actually the named range works better anyway in all versions of Excel. But could not simply select a sheet in XL2000 as I could in XL95. select A1:G50 then supply a name (ziplabels) in the name box to left of formula bar. If you are using XL2000, move the tab for the sheet to the far left and create a name for the data:

They only go up to AutoMergeField4 so failure to provide headings will limit In Word as AutoMergeField, AutoMergeField1, AutoMergeField2 etc. Failure to have column headings will show up See notes on zip codes if you are having a problem with zip codes in Excel.Ĭolumn headings are required in row 1 in Excel for field identification in Mail Merge. Will convert your table to labels without any problem and maintain the labelīoundaries therefore, Excel by itself is not suited to the task of creating labels, but Excel with Mail Merge in Word works just fine.ĭirections for preparing data in Excel to print Labels (#preparation) Excel does not give you reformatting options to createĪnother sheet using the information, you would have to write a macro. I found this a little tricky first time but have done this from both XL95 and XL2000.Įxcel makes a nice table column for name,Īddress, city, zip state, zip code. Using Mail Merge with data from Excel Location: Home page: Įxcel can be used to supply the data to mailmerge in MS Word. In the Envelopes and Labels window, click the “Options” button at the bottom.Mail Merge, Printing Labels using Mail Merge with data from Excel Mail Merge, Printing Labels Open a new Word document, head over to the “Mailings” tab, and then click the “Labels” button. Now let’s assume you want to print a bunch of labels on a single page, but print different information on each label. Make sure you have your labels loaded into the appropriate tray in your printer and then click “Print.”Ĭreating a Single Page of Different Labels When you’re happy with your setup, click “OK.” If you can’t find what you’re looking for, you can select “New Label” and type the exact details of what you need. You’ll notice the specifications of the labels will appear under “Label information.” The information displayed here is relative to the selected product number.

Under “Product number,” you can select the label type from the provided list. In the Label Options window, you can tell Word how you’ll be printing the labels and the brand of the label. To change it, you’ll need to select “Options.” Let’s go ahead and do that. The “Label” section gives you a description of your current label selection.