how do you make mailing labels from an excel spreadsheet

In that, click ‘Advanced in the left pane and scroll down to the ‘General’ section. Click on the ‘File’ tab and select ‘Options’ at the bottom of the left pane.Ī new ‘Word Options’ window will open up. To do this, First, open the Microsoft Word program. If you are connecting Word to Excel for the first time, you will have to enable a conversion format that will allow you to convert files between the two Microsoft programs. 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. 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 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. 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

How do you make mailing labels from an excel spreadsheet