Microsoft Word has intuitive ways to create labels for personal and professional use. You can create address labels, name tags, and product labels. In this guide, I’ll explain two ways you can make labels using Microsoft Office 2019, although the steps are the same for other versions of Word.
Creating a Single Label or a Page of the Same Labels
- Open a new blank document and click on Mailings from the top ribbon bar.
- In the “Create” group, select Labels.
- The Envelopes and Labels dialog box displays. Use the Address box to type the text you want to be printed on the label. Then, in the Print section, select Full Page of the Same Label to print a page of the same address labels or select Single Label to print only one label.
- Select Options to open Label Options.
- Choose the vendor in the Label Vendors list, then select the Product number matching the labels you want to print on. Click OK
- Finally, click New Document.
- That’s it! Word creates a new document with a page of labels formatted to the brand and label size you specified. You can edit them further if you like.
Using Mail Merge Wizard to Create Different Labels on One Page
By combining data you already have from an Excel spreadsheet, you can rapidly create personalized messages, emails, or labels in Word. Two elements are required for a mail merge:
- Excel source file with information about the recipients such as names, addresses, emails, etc.
- Your main document that will contain your label layout.
Creating Your Excel Spreadsheet (data source)
Before executing a Mail Merge in Word, make sure your Excel file contains all the necessary data, including:
- One row for each recipient.
- Column names that correspond to the Field names you wish to include in your mail merge. For example, if you want to address recipients by their first name, divide the first and last names into distinct columns. If you want to arrange contacts by state or city, ensure each has its own column.
Here’s an example of an Excel sheet ready for a mail merge:
Creating a Mail Merge Document on Word
- Open a new Word document.
- Navigate to the Mailings tab and select Start Mail Merge.
- From the drop-down menu that appears, click Step-by-step Mail Merge Wizard.
- Select Labels from the document type you are working on, then click Next.
- Click on Label options to select the Label vendor and the size or number of labels you want on one page.
- Click Next to Select recipients.
- Click on Browse to select your Excel recipient list file (data source)
- Select your recipient list file, then click Open.
- Make sure the First row of data contains column headers check box is selected, then click OK.
- Use the checkboxes to add or remove recipients from the merge, then click OK when your list is ready.
- Once you’ve checked your address list, the Next Record rule will display in all ] the blank labels in your template (apart from the first one)
- Place the cursor on the blank label template to add your design.
- Now click on Insert Merge Field and select the fields from the drop-down menu where you want them to appear.
- Once you are done, you’ll have the merge fields on your first label template, as shown below.
- Click on Update all Labels to apply the format to all label templates.
- Click on Preview Results to see how the info in your recipient’s list will appear in the final document.
- Use the navigation arrows to preview all labels individually as they get inserted into the label template.
- That’s it! You can now Complete the merge and save your label template by pressing Ctrl + S to print it later.