How to Create Mail Merge Labels in Word 2003-2019 & Office 365

When you need to print a large number of address labels, it can be tedious and time consuming to enter each person's information on your label sheet manually. Fortunately, Microsoft Word offers the mail merge feature to help users complete this process much faster. Mail merge is a popular tool for mass producing custom or personalised items but many people are unfamiliar with the term and unsure of how to utilise it for their projects. In the following article, we tackle some frequently asked questions related to mail merge and step-out how to create mail merge labels in every version of Microsoft Word. These tips will help with creating address or return address labels for business letters, company invoices, wedding invitations, name tags, and more.

Mail Merge Frequently Asked Questions

Here are answers to the internet's most searched questions on the topic.

What is mail merge?

A mail merge (or data merge) is a method of auto-inserting data. It takes the time and effort out of creating personalised content. A number of programs offer a mail merge tool to help with address labelling, name tag creation, certificate printing, email personalisation, and more.

How does mail merge work?

The mail merge functionality pulls the information from a list of data. It then inserts the appropriate fields into your document, design, email, etc.

What programs offer label mail merges?

Dozens of standard programs offer mail merge, but the most common for label mail merges are Maestro Label Designer and Microsoft Word.

Is mail merge free?

Mail merge in most programs is a free tool. It's included free in both Maestro Label Designer and Microsoft Word.

How do you create a data list for mail merge?

We explain this process below in Step 1: Create your data list.

What file formats are needed for mail merge?

Maestro Label Designer and Microsoft word accept .csv, .txt, .xls, and .xlsx file formats. Microsoft Word also accepts Outlook and Apple contact lists.

Step 1: Create your data list

Before Microsoft Word 2007 can auto-fill your labels, it has to access your data. If you already have your data set, move on to Step 2. If not, follow the below instructions for how to create a mail merge data list in Microsoft Excel.

1. Launch Microsoft Excel.
2. Title each column based on the data you'll be adding. If you're making address labels, for example, you may want to use the following column titles: first name, last name, address 1, address 2, city, state, postcode.
3. Add your data to each row and column.
4. Select "Save As" from the File menu in the top left-hand corner.
5. Give your document a name. Example: Wedding Invitation Address List.
6. Expand the dropdown for the "Save as type" option.
7. Choose any of the following formats: CSV (Comma delimited)(recommended), Text (Tab delimited), Excel Workbook, or Excel 97-2003 Workbook.
8. Click "Save". If you get any warning pop-ups, click "OK" and/or "Yes."
9. Close your document along with Microsoft Excel and continue to Step 2.

Step 2: Launch the mail merge wizard

Microsoft Word has a wizard that will walk you through the process from start to finish. Use the links below to jump to your version of MS Word then follow along with our directions while running the wizard.

Don't have your labels yet? Shop EU30015, our most popular address label configuration, or browse all of our address label products.

Microsoft Word 2003 Mail Merge

1. Open the "Tools" menu.
2. Click into "Letters & Mailings."
3. Select "Mail Merge."

   

4. Choose "Labels" then hit "Next: Starting document."
5. Choose "Avery US Letter" from the second dropdown list and find the comparable Avery® product number from our cross-reference chart or choose "New Label" to manually enter the label specs. Get in-depth instructions on creating a Microsoft Word template. Note: If you're using an Online Labels product, that information is available under the "Product Specifications" heading on each product page.

   

6. Click "OK."
7. Ensure "Use an existing list" is selected and click "Next: Arrange your labels."
8. Find your data set from Step 1 and click "Open."
9. Review the data in the next pop-up and click "OK."
10. Click "Next: Arrange your labels" again.
11. Move your cursor to the first label on your screen. Click "Address block" if you're creating address/return address labels and select your preferred formatting in the pop-up (use the preview pane to choose the best option for your data). If you're making another type of document, use the "Insert Merge Files" button in the "Mailings" tab. Be sure to add spaces, commas, etc if you're creating your own layout.
12. Hit the "Update all labels" button and then "Next: Preview your labels."
13. Check that your data copied over correctly and you're happy with the final result.
14. Click "Next: Complete the merge."
15. Close the wizard and save your document.

Microsoft Word 2007 Mail Merge

1. Open on the "Mailings" tab in the menu bar.
2. Click "Start Mail Merge."

   

3. Select "Step by Step Mail Merge Wizard."
4. Ensure "Change document layout" is selected and click "Next: Select recipients."
5. Choose "Avery US Letter" from the second dropdown list and find the comparable Avery® product number from our cross-reference chart or choose "New Label" to manually enter the label specs. Get in-depth instructions on creating a Microsoft Word template. Note: If you're using an Online Labels product, that information is available under the "Product Specifications" heading on each product page.

   

6. Click "OK."
7. Optional: Click into the "Layout" tab and select "View gridlines" to see the outline of your labels on-screen.
8. Ensure "Use an existing list" is selected and click "Next: Arrange your labels."
9. Find your data set from Step 1 and click "Open."
10. Review the data in the next pop-up and click "OK."
11. Click "Next: Arrange your labels" again.
12. Move your cursor to the first label on your screen. Click "Address block" if you're creating address/return address labels and select your preferred formatting in the pop-up (use the preview pane to choose the best option for your data). If you're making another type of document, use the "Insert Merge Fields" button in the "Mailings" tab. Be sure to add spaces, commas, etc if you're creating your own layout.
13. Hit the "Update all labels" button and then "Next: Preview your labels."
14. Check that your data copied over correctly and you're happy with the final result.
15. Click "Next: Complete the merge."
16. Close the wizard and save your document.

Microsoft Word 2010 Mail Merge

1. Open on the "Mailings" tab in the menu bar.
2. Click "Start Mail Merge."

   

3. Select "Step by Step Mail Merge Wizard."
4. Ensure "Change document layout" is selected and click "Next: Select recipients."
5. Choose "OnlineLabels.com" from the second dropdown list and find your label product number in the list.
6. Click "OK."
7. Optional: Click into the "Layout" tab and select "View gridlines" to see the outline of your labels on-screen.
8. Ensure "Use an existing list" is selected and click "Next: Arrange your labels."
9. Find your data set from Step 1 and click "Open."
10. Review the data in the next pop-up and click "OK."
11. Click "Next: Arrange your labels" again.
12. Move your cursor to the first label on your screen. Click "Address block" if you're creating address/return address labels and select your preferred formatting in the pop-up (use the preview pane to choose the best option for your data). If you're making another type of document, use the "Insert Merge Fields" button in the "Mailings" tab. Be sure to add spaces, commas, etc if you're creating your own layout.
13. Hit the "Update all labels" button and then "Next: Preview your labels."
14. Check that your data copied over correctly and you're happy with the final result.
15. Click "Next: Complete the merge."
16. Close the wizard and save your document.

Microsoft Word 2013 Mail Merge

1. Open on the "Mailings" tab in the menu bar.
2. Click "Start Mail Merge."
3. Select "Step-by-Step Mail Merge Wizard."
4. Choose "Labels" and click "Next: Starting document."
5. Select the "Start from a template" option and click "Next: Select recipient."
6. Choose "OnlineLabels.com" from the second dropdown list and find your label product number in the list.
7. Click "OK."
8. Optional: Click into the "Layout" tab and select "View gridlines" to see the outline of your labels on-screen.
9. Ensure "Use an existing list" is selected and click "Browse."
10. Find your data set from Step 1 and click "Open." You may also need to select a specific sheet from your document in this step.
11. Review the data in the next pop-up and click "OK."
12. Click "Next: Arrange your labels."
13. Move your cursor to the first label on your screen. Click "Address block" if you're creating address/return address labels and select your preferred formatting in the pop-up (use the preview pane to choose the best option for your data). If you're making another type of document, use the "Insert Merge Fields" button in the "Mailings" tab. Be sure to add spaces, commas, etc if you're creating your own layout.
14. Hit the "Update all labels" button and then "Next: Preview your labels."
15. Check that your data copied over correctly and you're happy with the final result.
16. Click "Next: Complete the merge."
17. Close the wizard and save your document.

Microsoft Word 2016 Mail Merge

1. Open on the "Mailings" tab in the menu bar.
2. Click "Start Mail Merge."
3. Select "Step-by Step-Mail Merge Wizard."
4. Click "Change document layout" then "Label options."
5. Choose "OnlineLabels.com" from the second dropdown list and find your label product number in the list.
6. Click "OK."
7. Optional: Click into the "Layout" tab and select "View gridlines" to see the outline of your labels on-screen.
8. Choose "Next: Select recipients."
9. Ensure "Use an existing list" is selected and click "Next: Arrange your labels."
10. Find your data set from Step 1 and click "Open."
11. Review the data in the next pop-up and click "OK."
12. Click "Next: Arrange your labels."
13. Move your cursor to the first label on your screen. Click "Address block" if you're creating address/return address labels and select your preferred formatting in the pop-up (use the preview pane to choose the best option for your data). If you're making another type of document, use the "Insert Merge Fields" button in the "Mailings" tab. Be sure to add spaces, commas, etc if you're creating your own layout.
14. Hit the "Update all labels" button and then "Next: Preview your labels."
15. Check that your data copied over correctly and you're happy with the final result.
16. Click "Next: Complete the merge."
17. Close the wizard and save your document.

Microsoft Word 2019/Office 365 Mail Merge

1. Open on the "Mailings" tab in the menu bar.
2. Click "Start Mail Merge."
3. Select "Step-by-Step Mail Merge Wizard."
4. Click "Change document layout" then "Label options."
5. Choose "OnlineLabels.com" from the second dropdown list and find your label product number in the list.
6. Click "OK."
7. Optional: Click into the "Layout" tab and select "View gridlines" to see the outline of your labels on-screen.
8. Choose "Next: Select recipients."
9. Ensure "Use an existing list" is selected and click "Next: Arrange your labels."
10. Find your data set from Step 1 and click "Open."
11. Review the data in the next pop-up and click "OK."
12. Click "Next: Arrange your labels."
13. Move your cursor to the first label on your screen. Click "Address block" if you're creating address/return address labels and select your preferred formatting in the pop-up (use the preview pane to choose the best option for your data). If you're making another type of document, use the "Insert Merge Fields" button in the "Mailings" tab. Be sure to add spaces, commas, etc if you're creating your own layout.
14. Hit the "Update all labels" button and then "Next: Preview your labels."
15. Check that your data copied over correctly and you're happy with the final result.
16. Click "Next: Complete the merge."
17. Close the wizard and save your document.

Step 3: Print your mail merge labels

Once your document is setup, formatted, and saved, it's time to print!

1. Load your mailing labels into the printer.
2. Use the "Print" button on the last page of the wizard or go to "File," "Print" to print as normal.

---

Mail merge is a quick and efficient way to create professional-looking labels and individualised content in no time. Use mail merge for business and personal projects, from return address labels to product barcoding. For more information on how to mail merge labels, call our customer service team at 0203 051 9664.

You may also want to shop address label sheets and pick a pre-designed address label template to make it unique!