How to Print Mail Labels From Excel
Printing labels from Microsoft Excel data is done by using the Mail Merge function. Using mail merge, you can specify the Excel data as your data source in the mail merge. During this process, you also specify the label type and product number. After the data source is specified, specify the format of your mail labels in the Word mail merge document. Print the mail labels after the format is specified and previewed.
Open Excel 2010 and select the "Mailing" tab on the ribbon. Select "Start Mail Merge." Click "Labels." Select the label vendor and product number. Click "OK." A grid of the label appears in your Word document.
Click "Select Recipients." Select "Use Existing List" from the drop-down list. Browse your files and locate the Excel workbook containing the mail labels. Click the workbook and select the worksheet containing the mail label information. Click "OK."
Format the labels by clicking the "Insert Mail Merge" field. From the drop-down list, select a field name. It appears in the first label in the document. Add a space or additional formatting as necessary. Press the "Enter" key to advance to the next line in the label.
Click the "Preview Results" button to see the labels. Click "Update labels" to apply the new label format to all of the new labels. Select "Finish and Merge" to print the labels. Select "Print Records" and "All" to finalize the print process. Click "OK" and review your printed mail labels from your printer.