How to Mail Merge Labels (A Step-by-Step Guide for Beginners)

How to Mail Merge Labels (A Step-by-Step Guide for Beginners)

- Published: - 10 minutes read

The days of hand addressing envelopes are over. If you’re looking for a simple way to create labels in bulk, you’re in luck. In this quick guide, we’ll show you how to mail merge labels using Excel and Word, or Google Sheets and Docs. Discover how to generate pixel-perfect labels that align properly when printed.

Imagine that you have a list of 50, 100, or maybe even 500 addresses, and you want to print each of those addresses onto a label to send a package or a letter to those recipients. How would you proceed?

One way to achieve your goal would be to create a new address label sheet in a text editor, such as Microsoft Word or Google Docs, then copy and paste each address into one of the labels and print your labels.

But if you have a long list of addresses, creating each label manually would take ages. Plus, this painstaking process would increase the risk of making mistakes. Fortunately, with mail merge, you can automate this process.

In today’s guide, we’ll show you how to mail merge labels using MS Word + Excel, or Google Docs + Google Sheets. Once mastered, this simple technique will save you hours of work each time you need to send a mass mailing.

What is a label mail merge?

A label mail merge is a powerful feature that lets you create a set of labels from a list of addresses (or other data). Instead of typing out each label, you can automatically generate labels using information from a data source.

To mail merge labels, you need to prepare your address list in a data source, like Excel or Google Sheets. Then, set up your label format in Word or Google Docs, and merge the 2 documents to create your labels.

Label mail merges are life-savers when you need to send out holiday cards, invitations, or business mailings. By automating your label creation process, they can help you make your mailings faster and error-free.

How to mail merge labels?

There are 2 easy ways to create mass personalized labels, even if you’re a beginner with no technical skills. You can (1) mail merge labels using Word + Excel. Or (2) create labels using Google Docs + Sheets. Let’s explore both methods.

Method #1: Create labels using MS Word and Excel

The first way to mail merge labels is to prepare an address list in Excel, create a label template in MS Word, then merge both documents. Here’s how to perform a label mail merge in Excel and Word:

Step 1: Create a new Microsoft Word document.

Step 2: Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard.

Step 3: Select Labels as your document type. Then click **Starting documents.

Step 4: Under Change document layout, click Label Options. Then choose the Label vendors and Product number. Then click OK.

Not sure what type of labels to select? You can find this information on the package your labels came in.

Step 5: Choose Select recipients. Then click Browse, select your data source, and press OK to confirm.

Make sure your address list (or data source) is properly formatted. The easiest way to create a list for your mail merge is to open a new Excel spreadsheet and create 2 columns: one for the full name of your recipients and one for their postal address. Then, fill these columns with your data.

Step 6: In MS Word, click Arrange your labels. Then select Address block. From there, you can choose the format of the recipient’ name you want to use in your label mail merge. Make sure to select Insert postal address. Then click OK.

Step 7: Your label template is now ready. To replicate this first label, select Update all labels.

Step 8: Click Preview your labels. From there, you can edit the spacing of your paragraphs and other details. This also lets you get a sneak peek of what your labels will look like once printed.

Step 9: Double-check your labels to make sure they’re error-free. Then, once you’re ready, click Complete the merge to finish the process. Then click Print > OK, select your printer, and press OK.

And voilà. You’ve created your first label mail merge using Word and Excel. Congratulations 🎉

Method #2: Create labels using Google Docs and Sheets

If you’re used to working with Google’s Suite, you can also mail merge using Google Docs and Google Sheets. To do so, you’ll need to install a special add-on called Labelmaker.

Labelmaker is a trusted add-on with 5M+ happy users all over the world and a 4.8 rating out of 13K+ reviews. This app is designed to respect your privacy. Here’s how to use it to create and print labels from Google Sheets and Google Docs:

Step 1: Go to the Google Workspace Marketplace and click Install to download the Labelmaker add-on.

Install a label mail merge add-on such as Labelmaker

Step 2: Sign into Labelmaker using your Google account. Then grant the add-on permission to access your Google Docs and Google Sheets documents.

Connect Labelmaker to your Google account

Step 3: Create a new document in Google Docs. Then go to Extensions > ** Create & Print Labels** > Create labels.

Open Labelmaker in Google Docs

Step 4: Under Label template, click Select a template.

Select a label template in Google Docs

Step 5: Select a label template from the list. There are over 5000+ labels available, within multiple categories such as “Avery® US Letter”, “Sheetlabels.com”, “OnlineLabels.com”, and “Herma”. Then click Use.

Choose the product number of your labels in Google Docs

Step 6: Next, let’s prepare your address list using Google Sheets. Open a new spreadsheet, add a header to each column, then fill your columns with relevant data about your recipients.

Prepare your address list in Google Sheets

Step 7: Go back to your Google Docs, and click Select a spreadsheet. Then choose the Google Sheets spreadsheet you’ve just created.

Select your Google Sheets spreadsheet as your data source in Google Docs

Step 8: Add text and formatting to the first cell of your Google Docs. You can use merge fields to insert dynamic content in your labels. To do so, under Add merge fields, select a merge tag, such as «First name», «Zip Code», or «City».

Add merge tags to personalize your labels in Google Docs

Step 9: Once your label template is ready, click Create labels to create a new document with a full sheet of labels replicated from the first label.

Mail merge your labels using Google Docs and Google Sheets

Step 10: Labelmaker will then replace your merge fields with the corresponding data from your Google Sheets spreadsheet, allowing you to generate personalized labels in bulk. To print your labels, go to File > Print.

Print your labels in Google Docs

In the print dialog, set the margin to None and the scale to 100%. Depending on your label product's format, you might need to adjust the page size. For example, Avery® US Letter 5160 labels require the page size to be set to Letter.

And that’s it. You can now use Google Docs + Google Sheets to create and print personalized labels in minutes with Labelmaker.

Wrapping up

Label mail merges are a game-changer for creating, formatting, and printing labels. Whether you’re using Microsoft Word and Excel or Google Docs and Sheets, you can automate the process and save yourself hours of work.

At Mailmeteor, we use mail merge tools like Labelmaker to design and print labels effortlessly. This allows us to prepare our mailings 10 times faster, while making sure our labels are always pixel-perfect.

Want to do the same? Create your free Labelmaker account to start merging labels today. And if you’d like to see what mail merge can do for your emails, check out our guides on how to mail merge in Gmail or Outlook.

FAQs — Mail merge with labels

Can you turn an Excel spreadsheet into Avery labels?

You can turn an Excel spreadsheet into Avery labels using the mail merge feature in Microsoft Word. To do so, prepare your address list in Excel. Make sure each column has a header (e.g., Full Name, Address). Then open Word, go to Mailings > Start Mail Merge > Labels. Lastly, choose the appropriate Avery label template and select your Excel file as the data source.

What is the easiest way to print address labels?

The easiest way to print address labels is by using a mail merge add-on such as Labelmaker to design professional-looking labels in Google Docs, and fill them with data from a Google Sheets spreadsheet. This solution doesn’t require any technical knowledge and it’s super fast!

How to make sticker labels in Excel?

You can’t print sticker labels directly from Excel. However, you can use Excel to prepare your data and then print your labels from MS Word. To do so, create an Excel spreadsheet and fill it with the information you want on the labels. Then go to Word and navigate to Mailings > Start Mail Merge > Labels. Lastly, choose your label type, connect your Excel file as the data source, and complete the merge to automatically generate your sticker labels.

Does Microsoft Word have a label template?

Microsoft Word has built-in label templates for various label types, including popular brands like Avery. To access these templates, go to the Mailings tab, select Start Mail Merge > Labels, and choose the label vendor and product number from the list. This lets you create labels that fit perfectly on pre-made label sheets, making your mailings look clean and professional.

This guide was written by Paul Anthonioz, content editor at Mailmeteor. Mailmeteor is a simple & privacy-focused emailing software. Trusted by millions of users worldwide, it is often considered as the best tool to send newsletters with Gmail. Give us a try and let us know what you think!

One giant leap for your inbox

Sign up for tips and industry insights to level up your emailing skills.

Explore more from Mailmeteor

Articles, examples, tutorials, and inspiration from our emailing experts.