Affiliate Disclosure: I may earn money or products from the companies and links mentioned in this post. I do use Google adsense, as well as Amazon associate links.

I’m a pro label maker. Just kidding, I’m not. In this post, I want to share with you how to quickly create labels with Microsoft Excel and Microsoft Word. There is nothing fancy about this. It’s a pretty easy and simple process. I think that teachers, educators, church leadership, and lay staff could appreciate this helpful walk through. I did this process on a Mac, but the idea is the same even if the button aren’t in the same place.

Step 1

Create a list in Excel.

Excel Screenshot

Pretty simple. Now save it somewhere where you can easily locate it. You can’t create labels in Excel without having an Excel spreadsheet first!

Step 2

Now open up Word. Click Tools, Mail Merge Manager (or labels…)

Screen Shot 2013-10-22 at 1.33.38 PM

1. Click Create New, Labels. Pick what type of labels you have.

2. Now click “Get List” and choose Open Data Source… then open your Excel file.

Screen Shot 2013-10-22 at 1.34.21 PM

Step 3

Insert your placeholders. These essentially tell the document where to put things. I drag them over into an entry and then copy and paste them into every little slot. I think that there is a faster way to do this on a Windows machine. Again, the logic is the same. Make sure after each one to put <<Next Record>>.

Screen Shot 2013-10-22 at 1.36.28 PMLabel entries

Step 4

Complete the merge. You can either open up a new documents with your labels or print directly. I like to open mine first.

Screen Shot 2013-10-22 at 1.38.20 PM

  1. Print
  2. Merge to New Document
  3. Merge to Email

When you merge to a New Document, you get this:

Screen Shot 2013-10-22 at 1.50.17 PM

Which you can also print.

That’s all folks!

Need more help? Want a video tutorial? Comment below and let me know!
Katie Allred

WHO LOVES EMAIL?

Get an email every time I update my blog. I write on church communications and the web, among other things.

You have Successfully Subscribed!