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?