![]() And in the following Select Table dialog box, select the sheet containing the mailing list, see screenshot:ħ. In the opened Select Data Source window, choose the Excel file you saved earlier, and click Open button, see screenshot:Ħ. Next, please click Mailings > Select Recipients > Use an Existing List, see screenshot:ĥ. Then, click OK button to close the dialog box. (In this example, I will choose Microsoft and 1/4 Letter separately.)Ĥ.Product number: Select product number listed on the package of label sheets.Label information: Choose supplier of label sheets.In the opened Label Options dialog box, set the Label information and Product number as you need: Save and close the workbook, then launch a Word document, and click Mailings > Start Mail Merge > Labels, see screenshot:ģ. Prepare the data information of your printing mailing labels, such as First name, Last name, Address, City, State, Zip Code as below screenshot shown:Ģ. In this case, the Mail Merge feature in Word document can help you to create the labels from Excel and then print or save them as you need.Ĭreate and print labels in Word from an Excel worksheet with Mail Merge featureġ. Each row in the worksheet needs to be transferred onto one label as below screenshots shown. Normally, we can organize a mailing list in Excel quickly and easily, but it’s not so convenient when it comes to printing the labels. How to create and print labels in Word from an Excel worksheet? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |