how to print address labels from excel 2016

When you start your mail merge process, your Excel file may or may not be open the process will work in either case. Generally, I use one font size larger and a bold characteristic. It is also important that the row containing column labels be formatted differently from the data contained in the list. Any empty row signals the end of the list data and any data following the empty row will not be included in your label selection. Most importantly, your data list cannot contain any empty rows. You will have greater success if your Excel data conforms to Excel's criteria for list management. You have to use Word's Mail Merge feature and choose the Excel file as your source data. Click OK.Excel does not have the capability to print labels directly from your Excel file. Click OK, in the Print dialog, specify the printing setting as you need. Click Finish & Merge > Print Documents, in the Merge to Printer dialog, check All or other options as you need.Ĩ. Then click Preview Results to view the labels, you can click to go to next or previous result.ħ. Then click Mailings > Insert Merge Field, then insert First, Last, Company, and you can change the orders of these fields.Ħ. Then in the Select Contacts dialog, select the contact folder you use, click OK, then in the Mail Merge Recipients dialog, click OK.ĥ. Under Mailing tab, click Select Recipients > Choose from Outlook Contacts (or Select from Outlook Contacts).

Then in the Label Options dialog, set the page format as you need.ģ. Enable the Word program, and click Mailings > Start Mail Merge > Labels.Ģ. Actually, you can use Word to finish this job.ġ. If now you want to print the contacts in Outlook as mailing labels, how can you quickly handle it without editing one by one. How to print Outlook contacts as mailing labels?

How to print address labels from excel 2016