Step-by-Step Guide: Generating Word Mailing Labels Using Your Excel Spreadsheet

Quick Links

You may be using Microsoft Excel to organize a mailing list neatly. However, when you get ready to print mailing labels, you’ll need to use mail merge to create them in Word from your Excel list. Here’s how.

Step One: Prepare your Mailing List

If you have already created a mailing list in Excel, then you can safely skip this test. If you haven’t created the list yet, despite Excel’s lack of the mailing label function, we still highly recommend you use Excel since it’s better for organizing and maintaining data than using a Word table.

The first thing you need to do is create a column header respective to the data that goes in each column. Place those headers in the first row of each column.

Which headers you include depends on which information you plan to use in the mailing labels. Titles are always nice, but it’s important that you know which title a person goes by before creating the labels. Also, if your list is for companies and not individual people, you can omit the “First Name” and “Last Name” header and just go with “Company Name” instead. To properly illustrate the steps, we’ll go with a personal mailing list in this example. Our list will include the following headers:

First Name
Last Name
Street Address
City
State
ZIP Code

This is the standard information you’ll find on mailing labels. You can even insert images in the mailing labels if you want, but that step would come later in Word.

Once you’ve finished creating the headers, go ahead and input the data. Once you’re finished, your list should look something like this:

Go ahead and save your list and let’s head over to Microsoft Word.

## Step Two: Set Up Labels in Word

Open up a blank Word document. Next, head over to the “Mailings” tab and select “Start Mail Merge.”

Kanto Player Professional

In the drop-down menu that appears, select “Labels.”

The “Label Options” window will appear. Here, you can select your label brand and product number. Once finished, click “OK.”

PCDJ DEX 3 for Windows & MAC is the total entertainment DJ software solution, offering audio, video, and karaoke mixing ability. Automatic beat-sync, smart looping, 4 decks, DJ MIDI controller support, Karaoke Streaming and much more.
DEX 3 meets the demands of today’s versatile DJ, without compromise!
DEX 3 (Audio, Video and Karaoke Mixing Software for Windows/MAC | 3 Activations and Free Updates)

Your label outlines will now appear in Word.

Note: If your label outlines aren’t showing, go to Design > Borders, and select “View Gridlines.”

Step Three: Connect your Worksheet to Word’s Labels

Before you can transfer the data from Excel to your labels in Word, you must connect the two. Back in the “Mailings” tab in the Word document, select the “Select Recipients” option.

A drop-down menu will appear. Select “Use an Existing List.”

Windows File Explorer will appear. Use it to locate and select your mailing list file. With the file selected, click “Open.”

The “Select Table” window will appear. If you have multiple sheets in your workbook, they’ll appear here. Select the one containing your list. Make sure to enable the “First row of data contains column headers” option if it’s not already and then click “OK.”

Your labels are now connected with your worksheet.

Step Four: Add Mail Merge Fields to the Labels

Now it’s time to add your mail merge fields in Word’s labels. Select the first label, switch to the “Mailings” tab, and then click “Address Block.”

In the “Insert Address Block” window that appears, click the “Match Fields” button.

The “Match Fields” window will appear. In the “Required for Address Block” group, make sure each setting matches the column in your workbook. For example, “First Name” should match with “First Name,” and so on. Once you’ve confirmed everything is set properly, click “OK.”

Back at the “Insert Address Block” window, check out the preview to make sure everything looks good and then click “OK.”

<> will now appear in your first label.

Head back over to the “Mailings” tab and then click “Update Labels.”

Once selected, <> should appear in every label.

KoolReport Pro is an advanced solution for creating data reports and dashboards in PHP. Equipped with all extended packages , KoolReport Pro is able to connect to various datasources, perform advanced data analysis, construct stunning charts and graphs and export your beautiful work to PDF, Excel, JPG or other formats. Plus, it includes powerful built-in reports such as pivot report and drill-down report which will save your time in building ones.

It will help you to write dynamic data reports easily, to construct intuitive dashboards or to build a whole business intelligence cockpit.

KoolReport Pro package goes with Full Source Code, Royal Free, ONE (1) Year Priority Support, ONE (1) Year Free Upgrade and 30-Days Money Back Guarantee.

Developer License allows Single Developer to create Unlimited Reports, deploy on Unlimited Servers and able deliver the work to Unlimited Clients.

Now, you’re now ready to perform the mail merge.