how to print address labels from excel spreadsheet

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 to print address labels from excel spreadsheet