If doing Labels you must choose the Label type.You must have your Word document already set up before starting the Label Merge.Make additions to your Excel table and save the table (you do not need to delete names, selection can be done later in Word).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. Follow Dave on Twitter.Mail Merge, Printing Labels using Mail Merge with data from Excel Mail Merge, Printing Labels Click Print to print your letters or Edit individual letters to further personalize some or all of the letters.Preview your letter and click Next: Complete the merge.Write a short letter and click Next: Preview your letters.
Note that the address block and greeting line are surrounded by chevrons (« »).In the Insert Greeting Line dialog box, choose the greeting line format by clicking the drop-down arrows and selecting the options of your choice, and then click OK.Press Enter on your keyboard and click Greeting line.Clicking Match Fields opens up the Match Fields dialog box, in which you can associate the fields from your list with the fields required by the wizard. Note that you can use Match Fields to correct any problems.In the Insert Address Block dialog box, check or uncheck boxes and select options on the left until the address appears the way you want it to.Click Address block to add the recipients' addresses at the top of the document.Write the letter and add custom fields.Selecting Edit recipient list opens up the Mail Merge Recipients dialog box, where you can edit the list and select or unselect records.Note that now that a list has been created, the Mail Merge Wizard reverts to Use an existing list and you have the option to edit the recipient list.Create a list by adding data in the New Address List dialog box and clicking OK.In this demo we will create a new list, so select Type a new list and then click Create. After you choose it, the Mail Merge Wizard reverts to Use the current document. Note that selecting Start from existing document (which we are not doing in this demo) changes the view and gives you the option to choose your document.Select Use the current document and then click Next: Select recipients. In this demo we will use the current (blank) document. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge.This feature works the same in all modern versions of Microsoft Word: 2010, 2013, and 2016. Mail merge is also used to create envelopes or labels in bulk. Using Mail Merge, you can easily customize form letters for individual recipients. Mail Merge is most often used to print or email form letters to multiple recipients.
How to Use Mail Merge in Microsoft Word See Microsoft Word: Tips and Tricks for similar articles.