how to print address labels from excel office 2016

NOTE: Manually select Labels from the Other Type menu if the inserted labels do not show on the Paper drop down menu. This policy setting controls whether sensitivity labels configured by an admin can be applied. I have a list of names and addresses that I need to place inside. Step-4: Inserting Fields to the Labels to Print Address Labels in Excel. Step-3: Creating a Connection of the Dataset with the Labels. Step-2: Selection of Labels in Microsoft Word to Print Address Labels in Excel. Select the inserted labels from the Paper drop down menu. Hello, I need a way to create and print labels from Excel without a mail merge from Word. Step-1: Creating a Dataset and Defining Name of This Range to Print Address Labels in Excel.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 office 2016