how to print address labels from excel to word

If you have a compatible template code select “Change document layout”, then click “Label options”.The Wizard will then guide you through the necessary steps, which are as follows: For earlier versions of Word, click on the “Tools” menu, select “Letters and Mailings” and then click on “Mail Merge”.) (For Word 2007 and after, click on the “Mailings” tab at the top of the page, click on “Start Mail Merge”, then select “Step by Step Mail Merge Wizard” from the list. Start the Step by Step Mail Merge Wizard.View our step by step How To video to learn how to use mail merge to make labels. Watch a video: this advice is also available in video format. This does tend to be slightly easier if you are using labels with a compatible template code, as these are built in to the Mail Merge function, but you can also use your own bespoke template to complete the mail merge. The template for the labels will be created in Word, but the data used to populate the labels will be drawn directly from the Excel spreadsheet.

The easiest way to accomplish this is to create the labels using Microsoft Word’s “Mail Merge” function. Most people who are printing labels from Excel are trying to create address or product labels, with each row in the spreadsheet needing to be transferred onto one label.

We’ve had a few enquiries asking for the simplest way to set up labels using text from an Excel spreadsheet. Or copy the link! Templates: from Excel to Word in a Mail Merge

How to print address labels from excel to word