8160 avery label template for word free mail merge

Using Mail Merge with data from Excel Location: Home page: Įxcel can be used to supply the data to mailmerge in MS Word. 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. 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. Si mi respuesta te ha servido, márcala como. If an answer provides a solution or you find it helpful, please mark it accordingly. If either is Auto, set it to zero or whatever you need to make it look nice. 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. If you dont have any blank paragraphs between lines of text, check the Space Before and Space After values in Format > Paragraph. 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. select A1:G50 then supply a name (ziplabels) in the name box to left of formula bar. Actually the named range works better anyway in all versions of Excel.īut could not simply select a sheet in XL2000 as I could in XL95. Named Ranges are known and available to the entire workbook.

8160 avery label template for word free mail merge