How to: Mail Merger on Microsoft Word (Video Walk-Through)
If you're looking to do any type of mailing, Mail Merging is a must. This function allows you to use information from an external file and put it into designated places on your design (This is much faster than manually entering in this information). So whether you have a few people or a large amount, this tool is great!
Key Information: Our example uses Microsoft Word 2010 and address labels.
Regardless - this functionality is present in all versions of Microsoft Word and is accomplished in a very similar manner.
Step 1 - Preparing the Mail Merge
Download, Save, and Open Your Template
- If you get a message in a yellow bar about “Protected View”, simply click the “Enable Editing” button.
Open Microsoft Excel
- Before we can get started on Mail Merging, we need to export the mailing list to a comma-separated file (.csv).
Step 2 - Creating the Mail Merge
Open the Microsoft Word Template.
Click the on Mailings Tab
- Located at Top of Document
- Select Start Mail Merge > Letters
- Click Select Recipients > Use Existing List
- Locate & Open the CSV Version of Your Mailing List
Click on Insert Merge Field
- You will see your column headings appear.
- Click on a Column that Corresponds with Your Information
Place the Merge Fields & Format the Document to Display it Correctly
- Click Preview Results to See How the Data Looks
Copy/Paste Information to the Next Label.
- The Data will be the same in both labels - We need to tell Microsoft word to move to the next record.
- To do this, Click Somewhere Before the Next Label Text Appears
Go to Rules > Next Record.
- You can click Preview Results to verify that it worked properly.
Copy & paste the second label text into the rest of your labels on the page.
- This tells the program to move to the next record for each individual label.
- If you are not making labels, just paste this information wherever you want your next record information to appear
Step 3 - Exporting the Remaining Data
Click on Finish & Merge.
A dialog should pop up after asking which records you wish to use. Select All to use all the information in the mailing list file. Select “Current Record” to only print one record. Or, select “From: ____ to ____” to print only a specific range of records.
I understand that the list looks a little daunting, but I promise it will save you time. Just go over each step, and you'll have your mailing list created and ready to print in no time!
Since 1995, we've hung our hats on delivering quality paper with an exceptional customer experience. When shopping with us, you'll discover a wide range of blank business cards, cardstock, stationery, greeting cards, menus, and more! If you ever have any questions, please don't hesitate to reach out.