How to Print Labels with Mail Merge in Microsoft Word and Excel

Brad Jones 16-02-2016

Mail Merge can save you time and effort, so learn the process from start to finish with this guide.


Just about everyone who’s familiar with the Office suite has heard of Mail Merge, but many don’t know exactly how the process is carried out. It’s easier than you might think — so long as you’re clear on how to set up your documents beforehand, and merge them in Word.

Once you’re up and running, you’ll be using this feature to create everything from customized index cards How to Make Index Cards in Microsoft Word 2016 Index cards are one of the best information organizing tools and memory aids because of their simplicity. Design your own with Microsoft Word and these tips. Read More to a mass mailing at your place of work. Mail Merge is only daunting for the first time, and you can prove that for yourself by working through this walkthrough.

We have used the new Office 2016 Upgrade to Office 2016 for Free Today with Your Office 365 Subscription Microsoft Office 2016 for Windows has landed and it brings many smart new features. If you have an Office 365 subscription, you can get it now for free and we show you how below. Read More for this guide, but the process applies to older versions of Microsoft Word and Excel.

How to Set Up the Source Document

Mail Merge works by populating specified fields on a document with data from another source, typically a database or spreadsheet Excel Vs. Access - Can a Spreadsheet Replace a Database? Which tool should you use to manage data? Access and Excel both feature data filtering, collation and querying. We'll show you which one is best suited for your needs. Read More . The first step toward a successful Mail Merge is setting up the source document, and ensuring that it’s formatted in a way that Word can understand.

Given that it’s the most common usage of this technique, our example will centre around placing individual names and addresses on a generic mass mailing. The fields we’ll include are Name, Company, Address, City, State and Zip Code — but these specifics aren’t essential, so long as you’re following the overarching process.


Using Excel

If you’re using Excel to build your source document, you simply need to produce a table of all the pertinent information that might be included in this Mail Merge, or a future mailing.

source document

The basic idea here is to split up your various piece of information into separate columns, and give each one an appropriate header. This makes it easy to pick and choose from those details later on, making it possible to use the same source document to create anything from an ID badge to an address label MovingLabelKit: Download Free Printable Moving Labels Read More .

Next, select all your data (including column headers), navigate to the Formulas tab and select Define Name.


define name

You’ll be asked for a name for your data set, so choose something appropriate. If you’re likely to oversee multiple Mail Merge projects for different mailings, it’s wise to add something recognizable to differentiate them further down the line. Once that’s done, save your work and close the spreadsheet.

Using Word

You can also use a Word file as your source document, but it requires a bit more effort. You’ll need to set up a table to keep things regimented 8 Formatting Tips for Perfect Tables in Microsoft Word Microsoft Word tables are essential formatting tools. Find out how to make a table and format it perfectly with these simple tips. Read More , so head to the Insert tab, find the Tables section and click the dropdown. Stipulate the size of table required for your project, and then start filling it with your data.

source document word


There’s no need to worry too much about formatting here, as this document is purely intended to act as a source file for your Mail Merge. However, accuracy is key, so make sure that all your data has been placed in the correct columns and properly titled. When you’re finished, save the document and close it for the time being.

Starting Your Mail Merge

Open Word and create a new document. Head to the Mailings tab and click the Start Mail Merge dropdown to select your desired project.

start mail merge

Here’s where the process might diverge a little, depending on what you’re looking to make. If I were making a label, or something else that might be printed on non-standard paper, I would be presented with another screen that allowed me to stipulate some additional printing options.


label options

In this case, choose the Default tray, unless you have reason to do otherwise, and then select the appropriate product number such that Word can apply the correct template.

Importing Source Data

With those foundations laid, we can now start importing information that we entered into the source document at the beginning of the process. Head to the Mailings tab once again, click on Select Recipients and choose Use Existing List.

source document selection

Navigate to your source document, whether it was created in Word or Excel — Microsoft’s Office suite will work together nicely How to Integrate Excel Data Into a Word Document During your work week, there are probably lots of times that you find yourself copying and pasting information from Excel into Word, or the other way around. This is how people often produce written reports... Read More in most situations. If you’re using a spreadsheet, you’ll be asked to confirm which table you’re selecting, and you should make sure the box marked First row of data contains column headers is ticked. Now head to the Write & Insert Fields section of the Mailings tab and click on Address Block (or whatever makes sense for your project).

insert address block

Here, you’ll be able to fine-tune exactly which fields are transferred from your source document to your finalized mailing. For even more options at this stage, we could have added the first, middle and last names of our recipients as individual columns, which would expand the list of available choices in the Insert recipient’s name in this format field. However, this is strictly optional.

The Address Block tool is great for anyone looking to speed through their Mail Merge, but if you want to stipulate exactly how your document is laid out 5 Ways to Strip Formatting When You Copy and Paste Text Here's how to copy and paste without formatting on both Windows and Mac using several convenient methods. Read More , consider using the Insert Merge Field option under the Write & Insert Fields section to place each field by hand. Once you’ve inserted your fields into the document, you can use Preview Results to see how it will print once populated.

preview changes

Now is the time to make any formatting tweaks that you might need to perform; changing the font, adjusting how each field will sit on the page, and any aesthetic flourishes you want to add. Once that’s done, navigate to the Mailings tab once again and click Finish & Merge under the Finish section. Your completed documents should be ready and waiting for you to print and mail.

For something a bit simpler, check out the best label makers you can buy The 7 Best Label Makers to Get Organized Here are the best label makers and label printers for organizing your home, office, garage, refrigerator, and more. Read More .

Related topics: Mail Merge, Microsoft Excel, Microsoft Office 2007, Microsoft Office 2010, Microsoft Office 2013, Microsoft Office 2016, Microsoft Word.

Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.

Whatsapp Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Heather Chapman
    January 31, 2018 at 5:42 pm

    Every time I print, I am only getting one label per page, not the 30 that should fit on an Avery 5160 label. Thanks or your help!

  2. Brenda
    February 17, 2017 at 11:31 pm

    I am printing the address directly on a Publisher newsletter instead of using labels. The only problem: it takes too long to print. Anything I can do? I need to print 900 newsletters. I don't have to print then all at once....I can divide them into smaller groups.

  3. Maggie
    August 27, 2016 at 1:34 am

    This all seemed to work fine except that it only printed one page of labels which is only 30 people on my excel spreadsheet of 95. Where are the other pages of labels???

  4. Kathy
    August 24, 2016 at 9:54 pm

    I have a word document that is an extensive contract. The contract is set up with formatted paragraphs that are numbered and lettered. The contract prints out fine but when I merge it with an excel spreadsheet in order to populate the contract the numbering and lettering are skewed. Please help!