how to print address labels from excel spreadsheet

The mail merge feature will allow you to easily create labels and import data to them from a spreadsheet application. Open the “Mailings” tab of the Word ribbon and select “Start Mail Merge > Labels…”. How to mail merge labels from Excel to Word labels.Once everything has been prepared with the correct column headers, you can save your work and continue to the next step to create labels from Excel. If you’re using your labels for a mailing list, you may want to include heading labels like first name, last name, and title. This will help you to match your fields to the correct columns later on.įor example, in ours we’ll be using the fields property name, operator name, address, city, state, zip code, and country. The important thing to remember is that you must create a column header noting the information that will go in each heading. If you don’t have one, you can create one now.

We’ll discuss this in the first step: How to Print Labels With Mail Merge From Excel to Word Labelsīefore you can create labels from Excel, you’ll need your existing mailing list in the application. Secondly, you will have to set your columns up properly in Excel to make this as seamless as possible. Firstly, though the tutorial will focus on address labels, it can be modified to work with any label. It’s worth noting two things before we start. If you have both applications installed, you can quickly and automatically import the data from your Excel spreadsheet into Word and have it displayed in an organized manner for printing. Though Excel’s built-in functionality isn’t great for label making, the beauty of the Microsoft Office suite is its cross-compatibility. How to Print Labels From Excel – It´S Easy Today we’ll be showing you how to make and print address labels from Excel with a little help from Microsoft Word and the mail merge feature. Typing out all of the information you have already entered would be time-consuming – but thankfully you can have your cake and eat it too.

3 Extra: How to Make a Page Landscape in WordĮxcel is an incredibly handy tool for organizing a mailing list, but it’s not so great when it comes to actually printing the labels.

2 Extra: How to Combine Text Cells in Excel.

1 How to Print Labels With Mail Merge From Excel to Word Labels.

How to print address labels from excel spreadsheet