how to print address labels from excel 2016

Use the Microsoft Word's Find and Replace formatting tool to replace all the pre-designed template text in each label with your own information.

Continue with Step 3 until all labels are filled with your information.

Position the cursor in the next label, right-click and select Paste.

Immediately, you’ll see the information printed on the document. Make sure ‘All’ is selected and press ‘OK’. To finish it up, click the ‘Finish & Merge’ icon at the ‘Finish’ group and select ‘Edit Individual Documents’ from the options. Then, click on the Select Recipients button in the Start Mail Merge section of the Mailings tab of the ribbon and navigate. Click the ‘Update Labels’ icon from the ‘Write & Insert Fields’ group on the Ribbon.

Highlight all the content in the first label, right-click and select Copy Instead: From the Start Mail Merge dropdown in the Start Mail Merge section of the Mailings tab of the ribbon, select Labels and then in the Label Options dialog that opens, select the type of label that you will be using.

Insert your information on the 1st label.

How to create a sheet of all the same labels:

Then click Text Wrapping and select In Front of Text in the drop down list. Select your image in the template and click the Page Layout tab in the Ribbon Toolbar. Highlight the text you entered and use the tools in Microsoft Word to format the text.Ĭlick the Insert tab in the Ribbon Toolbar to insert your own image, clip art, shapes and more. Once the file is open, type your information into the template. If the template looks like a blank page, select Table Tools > Layout > Show Gridlines to view the template layout. Word also has a Step by Step Mail Merge Wizard (found under the Mailings tab > Start Mail Merge button), which basically walks you through the process above.Double-click the Avery Word Template file you downloaded and saved to your copmuter.

In addition to letters (which can be any sort of document, including certificates and coupons), you can choose emails, envelopes, labels, or directories as the document type. Repeat this for other types of documents you'd like to use mail merge for.

How to print address labels from excel 2016