Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Forecasting and Modeling
      • Alteryx
        • Introduction to Alteryx
      • Power BI
        • Power BI – Beyond the Basics
        • Power BI
      • Qlik Sense
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop
      • Python
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up
Home > Microsoft Word > How to do a Mail Merge in Microsoft Word 2013 – Part 2

How to do a Mail Merge in Microsoft Word 2013 – Part 2

Microsoft Word allows users to execute the Mail Merge function through a Mail Merge Wizard. Picking up from the previous video, the final two steps in the wizard process are Previewing and Completing the Merge. The wizard contains numerous templates for step 2 of the wizard process, which are available both locally and online via Outlook.com; these templates are categorized for the user’s benefit, and involve specific Form Fields. As an alternative to the wizard, Word contains manual commands for the Mail Merge, such as Select Recipients, Edit Recipient List, and Insert Merge Field.

Watch the free video here, transcripts for the entire video follow:


Facebook Linkedin Twitter

Learn how to master Microsoft Word 2013. Get 9 hours of Word 2013 training – click here.

Video transcripts:

Welcome back to mail merge in our course on Word 2013. In the previous section, we prepared a mail merge and we got right through to the point where we’re previewing the letters. This is the first of the five mail merge letters. And in this section, we’re going to look at how we finish off the mail merge, actually execute the mail merge, and then we’re going to look at two or three of the specific additional points, variations, and special cases that I mentioned in the first section. And the first thing we’re going to do now is to save the letter that we’ve used in case we have to come back and do some more work on it later and also to use it as a kind of model for future mail merge letters.

 

MS Excel 2013 professional training by Simon Sez IT

 

So I’m going to save it as. I’m going to go into Computer, into the Example Files, and I’m going to save it as example-16. And in fact if you look in the list of files that came with this course that is example-16. Now having saved it, the name of course appears at the top. Let’s get back to this previewing.

Now when it comes to previewing letters, it’s pretty straightforward case of just stepping through them. So we’ve got controls here on the right. Note also and particularly this is true when you get towards the end of a mail merge, almost all of the commands in the groups on the Mailings Tab are now available and you can use those, for instance to step through recipients. Let’s go to recipient 2, just click on the right arrow there, Mr. Peter Stanley, Dear Pete, that’s fine. Dr. Emelia Sanchez, Dear Dr. Sanchez, yeah that’s fine. You may want to step through them all individually. You may think that a particular recipient may have caused a problem and you’ve got a Find a recipient option there. You can look for a particular person in the list. You can also if you see a particular letter and think, ah, I didn’t mean to send them that or that’s really gone completely wrong. You can click on Exclude this recipient to remove one of the recipients from the list. So this really is your opportunity to fine tune the list and also, of course, you may see an error in the letter that means you’ve got to go back and edit the letter and go through some of the earlier processes again. But I’m going to assume here for the moment that everything else has gone okay and I’m going to go down to Next, Complete the merge.

Now this last step is also one that sometimes causes a little bit of confusion, so let me explain this in a little bit of detail. The mail merge hasn’t actually happened yet but we’re pretty much ready for it and there are really two options. Now if you click on Print which basically says Merge to printer, what will happen is it will, by default, just print all of the letters; so it merges them all to the printer, prints them all. You can if you want just merge the current record or you could select a range and given that we’ve got five letters, I could say one to four or three to five or something like that. So that’s the basic way of printing the letters.

If on the other hand you want to look at the individual letters after the merge, this is where you use the second option, Edit individual letters, and again you can do all the current record or a range. So why would you want to do this? Well, let’s suppose that you’re completely happy with the basic letter that you’ve done and you’ve generated in my case five letters or maybe 500 or 5,000, but you want to be able to go through and find two or three individual people where you want to maybe add a little extra note; you want to write something different to them. Now, of course, we could’ve excluded them from the recipient list and written them a separate letter, but this is a good alternative. It means you can go through and maybe add something or even remove something from individual letters. When you’ve finished processing one or more individual letters, you can then just print the whole lot because they’re all contained in one document with a whole load of letters in it. So that’s basically how you complete the mail merge.

And when you’ve done your print or you’ve created that file that you’re going to go away and edit to do a bit of individual editing and customizing of letters, all you need to do is to close the Mail Merge Wizard and it’s done. You can then close the file we’ve been working on, click on Save, and we’re all done.

So having successfully completed one mail merge, let’s have a look at some of the options related to mail merge, including one or two of the things that I mentioned earlier on. I’ve started the Mail Merge Wizard again and this time I’m going to go into Step 2 from Step 1. One of the question there, How do you want to setup your letters? Use the current document. That’s what we did last time. We typed in the content and then later on put in the merge fields, but what about start from a template? Now if you want to start from a template, there are a number of templates available with Word 2013 and many of those are mail merge templates.

 

Learn Microsoft Word 2013 training online course

 

So let’s take a quick look at how we would do that. First of all, click on Select Template. Now Select Template gives access to templates that are available locally on the device. We’re going to look at templates on Office.com. So I’m going to press this button down here, Templates on Office.com. Now when you do this, you may not quite see the same as this because Microsoft.com does change quite a bit. The pages are replaced and refreshed on a fairly regular basis. But when you get into the area of Office Templates, you need to go to Word, so I click on Word first, and then I also have a Search box, Search for Word Templates. What I’m going to do is to search for mail merge templates. So I type in Mail Merge, hit the magnifier, and it comes up with a number of mail merge letter templates. There are quite a few of these templates. You can see on the left quite a long list of them: Letters, Print, Stationary. Let’s stick with a letter. Let’s go for this particular letter, the Equity theme letter. And we can see the rating. Click on download. I have quite a lot of security on the internet here so I have to allow pop-up blocker. You may have a similar thing on your device. So we’ll just give it a time to get past that, to actually download again for some reason, but eventually I will get that letter. So there we are. I go into Mailings and I’ve got my document. I could actually go through now, same procedure that we used before and setup my mail merge.

Now on this particular letter has got a couple of interesting things about it. First of all, I’m just I’m just going to zoom in on this part of the letter. The items in the letter that are between the double angle brackets are basically the merge fields. So what you have here, Greeting line, that will be a merge field. And when you want to setup your data you would need a data item whose name was Greeting line. Address block would pretty much work the same way that address block worked in the previous example, in the last section. The items that are between square brackets are what are called Form Fields. We’ve seen these before. I’ve referred to them as form fields or placeholders. But the difference between them is that these form fields are effectively the things that you are going to enter as a fixed part of your letter. So for instance, I might put today’s date in here and that’s it for this letter. It’s effectively then a fixed part of data in this letter. It is not one of the merge fields. Similarly, if I wanted to put the company name in here that again is a fixed part of the letter. And I can put my sender address there as well. Similarly towards the bottom of the letter I’ve got other fields to fill in. Notice that when I filled in Acme Engineering Inc. as a form field, it appeared at the bottom as well. So if you’re using one of these templates letters, you’d need to fill in those form fields yourself and then what remains, the merge fields, the one in the angle brackets are the ones that you’ll setup in the merge. So let’s see how we could set about merging with this particular template.

Well, I’ve setup my document. I filled in all those form fields. I’ve got the merge fields left, just those two sets of merge fields. I don’t really need to use the Wizard now. I’m going to go to the Select Recipients button first and it says, Type a new list, Use an existing list, or Choose from Outlook Contacts. I’m going to use an existing list and what I’m going to do is use the list that we created in the last section and just to help you, there it is, Demo 1.mdb, but I’ve also put the list that we created earlier into the standard folder for the example files and it’s included with the files you got in the course. It’s example-16.mdb. So double click or open that one. So let’s just confirm that. Go into Edit recipient list. There’s the list of people. Don’t worry too much if the order has changed or the order of the fields has changed, Word 2013 does certain things to these lists itself. You can change the sort order anyway if you want to. But there’s the list. If you didn’t want to use all of these people, you could use the check boxes here to eliminate some of the recipients from the current mail merge. But there are the mail merge recipients. The only real issue I’m going to have here, as you may have guessed, is that when I created this list, I called the field here Salutation rather than Greeting line. A couple of ways around that; I could either create a new field and copy these values into it, but I could just change the merge field in the document and that’s going to be the easiest way to do it. So I’m happy with the recipient list. I’m going to select the Greeting line. I’m going to press the Delete key and then I’m going to insert a new field. Note up here that I’ve got a command button, Insert Merge Field. The one I’m going to put in is Salutation. I may choose, for instance, to make that bold. So I can make that bold, and now let me just preview the result. So click on preview results, and there we have the first merge done. It’s to Jane Doe. I can review all of that letter. I could perhaps just zoom out a little, see a little more of it, scroll down, see the closing part, and then I can step through the recipients, check each of those, and all of the finishing merge options like printing, merging to a file, and so on, all of that is still available to me.

So in that second example we’ve pretty much done everything manually and this leads us to the next exercise for you to do because I would like you to use that same letter template. It doesn’t really matter if you want to use a different letter, but you’ve seen that one now and you have some idea of what goes where. You can either use example-16.mdb in the file with those five people in it or better still create your own recipient list, and I’d like you to do a mail merge with that letter and at least five recipients. My version of the saved output of that mail merge is example-17. When you open example-17, you’ll see that it’s got five full letters in it and you’re equivalent output, depending on what letter you choose, what recipient list you choose, and so on should have at least five pages of output as well.

Okay that’s it on mail merge. I’ll see you in the next section.

 

Microsoft Excel 2013 course

 

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

30 day vertical banner

Most Popular Posts

  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
  • How to Create Charts and Graphs in Microsoft Excel 2016

START LEARNING How to do a Mail Merge in Microsoft Word 2013 – Part 2 ON SIMONSEZIT.COM

START MY MEMBERSHIP

Similar Posts

Linking Shapes and Diagrams in Visio 2010

Using SkyDrive in Windows 8

Adding New Users, Password, Picture Password, and Pin in Windows 8

How to Set Out Of Office in Outlook App? 2 Easy Methods

How to Pay Bills for Vendors in QuickBooks 2019

How to Delete a Page in Word?

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2022 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)