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.
Create a list in Excel.
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!
Now open up Word. Click Tools, Mail Merge Manager (or labels…)
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.
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>>.
Complete the merge. You can either open up a new documents with your labels or print directly. I like to open mine first.
- Merge to New Document
- Merge to Email
When you merge to a New Document, you get this:
Which you can also print.
That’s all folks!