how to print address labels from excel 2016

If your label size doesn’t have a compatible code, you will need a saved copy of a suitable Word label template OR the measurements of your A4 labels. Ideally, you should use a compatible template that is built into Word. You can use an Excel Spreadsheet, Outlook Contact List, Office Address List, Word Data File, Access Database, or Text File. A data source (your list of addresses).This guide will explain how to use Mail Merge to combine a Word label template with a saved list of addresses to create individual address labels. Template Tuesday Presents.how to use Mail Merge to create individual address labels. NOTE: Manually select Labels from the Other Type menu if the inserted labels do not show on the Paper drop down menu.Or copy the link! How To? – How To Print Address Labels Using Mail Merge In Word Select the inserted labels from the Paper drop down menu.Create and format the document as required.Click on New Document to Create a Document Template based on the Label Type.NOTE: If the Product Vendor or Product Number is unavailable, select a Label type that closely matches the Label design, or contact the Label vendor for support. Select the Type of Labels used from the Product Number field.Select the Brand of Labels used from the Label Vendors drop down menu.Select Bypass Tray from the Page Printers drop down menu.NOTE: Load US Letter or A4 Size Label sheets in Long Edge Feed (LEF) Orientation.

The Tray Confirmation Screen will now display at the Control Panel. Insert the Labels into the Bypass Tray Face Down (print side facing down).NOTE: Use only Labels designed for the Laser printing process. DocuShare Enterprise Content Management.

How to print address labels from excel 2016