How to Make Mailing Label

Dave Andrews

Video transcription

Hi, my name's Dave Andrews. Today, I'm going to show you how to make mailing labels from an Excel spreadsheet. Let's go to our computer and we may open up Excel, go into all programs, Microsoft Office, and let's open up Excel. Now, I have a document created here called People.xlsx. What I've done is in the first row I've put first name, last name, address, city, state, and zip. And what I'm going to do after that first row is I'm just going to start typing some people's names, so if I type here, you know, I add a person by adding in their their information. And then, let's just say that once we have our list of people created and close it. Now, what we're going to do is a is a Word mail merge to create our labels, so click All Programs. Let's go to Microsoft Office and open up Word. What we're going to do here is we're going to go to Mailings, and then we're going to click Select Recipients under the Start Mail Merge tab, and click Use Existing List. Let's go to the documents where I have my Excel spreadsheet saved. There's People.xlsx. I'm going to choose it and click Open. It's going to ask me what sheet in the workbook I'd want to use. I'm going to use sheet one cause' that's the default and the first row of my data contains the column headers. Let's click OK there. Now, let's click Edit Recipient List. As you can see, this has loaded in the information here. There's my last name, first name, address, city, state, and zip. It's it's already interpreted all that and loaded it in for a mail merge. Let's Click OK. Now, click Start Mail Merge, and we're going to go with Labels. I'm going to use the Avery 5154 template, but basically you would choose the whatever label sheet you have bought you would choose the maker of that and the template for the design that you are going to go with, so I'm just going to pick one of these here and click OK. Now, I'm going to insert an address block by clicking here Write & Insert Fields, Address Block. Now it gives you a preview of what that address is going to look like formatted. There's only two records so click OK, and then click Finish & Merge, and just click on Edit Individual Documents. You want to merge all those records in. So, there are the records out of my Excel spreadsheet that have been loaded into Word for a mail merge. My name's Dave Andrews, and I've just showed you how to create mailing labels using Excel.