Get my FREE 2-hour Introduction to MS Word 2016 course here ► https://simonsezit.leadpages.co/word-2016-free-course/

Get the complete 6-hour Microsoft Word 2016 training course here ► https://www.simonsezit.com/courses/microsoft/learn-microsoft-word-2016-training-tutorials/

During this Microsoft Word 2016 training tutorial video, we will take a look at merging labels using the Mail Merge Wizard.

Checkout some of our other training on YouTube:

Word 2016 training tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jgtGiSa2PZppieNO0_4CUY

PowerPoint 2016 training tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jj_QkuckJNn8RddhwlQKOM

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Excel 2016 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2

Project 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gPqakrFQ8fSNPu00rsOuzu

Stay in touch:
SimonSezIT.com: http://www.simonsezit.com/
StreamSkill.com: http://streamskill.com
YouTube Channel: http://bit.ly/foiItB
Facebook: http://on.fb.me/14m8Rwl
Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Hey it’s Cindy again. We are still working in module 12 of Microsoft Word 2016 and we’re all the way down to section 5 where I’m going to talk to you a little bit about merging envelopes and labels.

So you’re already merged all of your letters or your main documents and you want to go ahead and send those out. Now you could actually merge envelopes and stick the envelopes in the printer but most people don’t do that because they don’t have time to babysit the printer. So we’re going to look at merging labels.

When you’re merging your labels you’ll want to start on a new blank document. From there you’re going to go to the Mailings tab and back to the Mail Merge Wizard. On step one of the wizard it asks what document type are you trying to create and before we had worked on letters. Make sure you’re on Labels this time and then click Next at the bottom to go to step two.

Here at the top it asks you, Would you like to change the document layout or start from an existing document? If you change the document layout you can choose the Label Options here. These are the same label options we saw when we were working on envelopes and labels in a previous module.

The next thing you want to do is make sure you’ve chosen the particular product number that matches the labels that you have. Now typically on the outside of the box they will say something like Corresponds with Avery U.S. Letter 8160. But you can also look sometimes at the bottom of the actual page of labels and it will say the number down there as well. So you just have to look for that.
I’m going to click OK here and now you’ll see my actual labels. Now I’m going to click Next to select my recipients.

And I’m going to hit Browse and here’s where I’m going to look for my data source. Now I’m going to pick this Excel file called New Merge Data and when I click Open it’s going to ask me which sheet in the Excel file do you want to pull from. I only have one in this exercise so I’ll click OK and now you’ll see all of my recipients here. Since I’m just going to merge them all I’ll just click OK at the bottom and now we can go to the next step and arrange the labels. So here’s where we will be pulling in all of our merge fields. When you do this pull them onto the first label because once you do that then we can update all of the labels over here.

So I’m going to go ahead and pull in some merge fields. I’m going to pull in the person’s first and last name. I’ll pull in their company. I’ll go ahead and pull in their address and then I’ll pull in their city, state and zip. State and zip. Now if you notice mines a little large and it doesn’t fit right in there. So what I’m going to do is go ahead and select these and I’m just going to make the font a tad smaller and it fits right in there.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.