How Do You Print Labels From Excel

Column names in your spreadsheet match the field names you want to insert in your labels.

Set up labels by opening a blank document and going to mailings start mail merge labels. Choose the brand and product number. Step 1 add data into excel create a new excel file with the name print labels from excel and open it. As we want to create mailing labels make sure each column is dedicated to each label.

To create and print the mailing labels you must first prepare the worksheet data in excel and then use word to configure organize review and print the mailing labels. Match the address block names on the left with the fields from your excel spreadsheet on the right. To print labels from excel you need to prepare your worksheet set up labels in microsoft word then connect the worksheet to the labels. Add the details in that sheet.