![how to convert excel file to word labels how to convert excel file to word labels](https://i.ytimg.com/vi/JDTiCYCmBME/maxresdefault.jpg)
You will need to connect the Word document to the Excel worksheet containing a mailing list to print your labels. If the name has more the one word, add underscore (_) between them (No Space or Hyphen allowed). Next, go to the ‘Formulas’ tab and click on the ‘Define Name’ from the Defined Names group.Ī new dialog box will open, enter the name in the ‘Name’ box, and click ‘OK’. Select the list of addresses in the Excel sheet, including the headers. Name the Mailing ListĪfter you created the data set, give a name to the data presented in the worksheet. When you are entering data, make sure your worksheet doesn’t contain any empty rows or columns. Save the worksheet once you have finished entering data. For example, rather than creating a single name column, split the name into separate columns such as title, first name, middle name, last name, which would make it easy to merge data with Word document. When you enter data in Excel, break down the information into individual columns. Since we want to create mailing labels, create a column for each element you want to add to the labels (like first name, last name, address, etc.).įor example, if you are going to create mailing labels from an Excel sheet, it would probably have these basic contact information (as column headings): Type the column header in the first cell of each column and fill the respective information under those column headers. To create and print the mailing labels, first, you need to set up your worksheet properly.
![how to convert excel file to word labels how to convert excel file to word labels](http://2.bp.blogspot.com/-CAfaxZzJgoA/TwMghrpUpuI/AAAAAAAAAOo/N_XUEj-CBZs/s1600/empty+boxes.png)
#How to convert excel file to word labels how to
If you don’t know how to mass print your labels from Excel, then read this step-by-step guide. With the Microsoft Word Mail Merge feature, you can create a sheet of mailing labels from an Excel Sheet that you can print.
![how to convert excel file to word labels how to convert excel file to word labels](https://i.ytimg.com/vi/2QPxSMDk0ug/hqdefault.jpg)
How to Make Mailing Labels in Word from an Excel Sheet By creating a mail merge document in Microsoft Word, and linking this to an Excel worksheet, you can pull the data from the Excel list, into printable labels for mailing. Let’s say you want to send a mass mailing to a mailing list that you maintain in an Excel spreadsheet, the best way you can do that is by using the Microsoft Word mail merge feature. But printing mailing labels, envelopes, greeting cards, or anything else could be hard work. You can easily organize a mailing list/address list in Excel. Microsoft Excel is the ideal place for storing the contact and address information of customers. In your document, continue inserting any fields you want in the merge.Ĭhoose Finish & Merge > Edit Individual Documents, make sure All is selected and click OK.If you want to print mailing labels from an address list that you maintain in an Excel spreadsheet, you can use Microsoft Word’s Mail Merge feature If the Address Block does not show the correct information (names, address, city, state, and zip) you can use Match Fields from the Insert Address Block dialog box or you can click Insert Merge Field and putting in the address fields. Press Enter several times, and insert an Address Block to show the recipient’s name. Type the date and any other information you want at the top of the letter. Pick Open and pick the correct worksheet. On the Mailings tab, in the Start Mail Merge group, choose Start Mail Merge > Letters.Ĭhoose Select Recipients then Use an Existing List. In Word, choose File > New > Blank Document. To perform a Letter mail merge in Microsoft Word Make sure the 1st row in Microsoft Excel is your header row when doing a mail merge in Word. If you were sending your customers a letter, the Excel file would include Company Name, First Name, Last Name, Address, etc. One of the easiest data sources to use is Microsoft Excel.
![how to convert excel file to word labels how to convert excel file to word labels](https://i.ytimg.com/vi/vF63j3Ecocw/maxresdefault.jpg)
It contains the records Word pulls information from to build the addresses for the labels, letters, or envelopes. The mailing list can be an Excel spreadsheet, a directory of Outlook contacts, an Access database, or an Office address list. To perform a mail merge with Microsoft Word, you need a data source or a mailing list.