how to print address labels from excel data

You will now see on your Word screen, a layout of all the labels, empty.In the dialog box, choose the labels you will use (the most common is 5160) and click OK.In Word, go to Mailings.Start Mail Merge.Labels.Step 3: Create the Word file, Complete Merge and Print The most common address label to use is a 5160 label size. It's important to know before you start the size of labels you are going to use so you can set the document up properly. Step 2: Find the labels you will Use (size) For example, first name, last name, address, city, state, and zip. In simplest form you will gather information into a simple spreadsheet that looks something like this, with separate columns for each piece of information. Whether it's a shower, wedding, graduation, newsletter, business announcement or some other reason for mailing to a group, you probably have or have gathered a list of names and addresses and need to get them into labels. Whether it's for work or for personal reasons, odds are at one time or another - you'll need to print out labels with mailing addresses. Print Mailing Labels in Word from an Excel list

How to print address labels from excel data