(888) 388-2502

Blog Categories

RSS
Join the conversation

Print Mailing Address Labels By Opening A SheetLabels.com Label Template & Using The Microsoft Word Mail Merge Manager!

July 26, 2013

If you need to print tens or even hundreds of mailing address labels, you should be able to do it quickly and effortlessly. Using the step-by-step directions listed in this blog post you are going to be able to do a basic mail merge using Microsoft Word.

First, open your mailing list. Most people have their mailing lists in the form of a Microsoft Excel document. Because these are mailing labels, be sure that you have columns in your document for:

  • First Name
  • Last Name
  • Street Address
  • City
  • State
  • Zip Code

Because you’re printing mailing labels on labels you ordered from SheetLabels.com, open the corresponding label template in Microsoft Word. Take your mouse to the left navigation on the SheetLabels.com homepage and click where it says “Templates”.

This takes you to the templates page. Find the correct SL number that corresponds with the labels you’ve ordered and then click on the Microsoft Word document icon. Once you click that icon a box appears. It says, “Open with Microsoft Word”, click the “OK” button.

To start the mail merge process, take your mouse and click on “Tools”. Scroll through the options and click on “Mail Merge Manager”.

Once you’ve clicked “Mail Merge Manager” a box appears. This box is going to walk you through the steps of the mail merge process.

Step one is to “Select Document Type”. Click “Create New” and a dropdown appears. Because, you’re making mailing address labels, click “Labels…”

Once you’ve clicked “Labels…” another box generates where you’re able to choose your label size. Because, you’re already using a SheetLabels.com label template, click “Cancel”.

Now move down to step two. Click “Get List”. To open a document that’s saved on your computer, click “Open Data Source”.

A box opens. Find the document in your saved files and open that document. Another box generates that says “Open Document in Workbook” click “OK”.

The mail merge manager automatically moves you down to step three. Click the “More” tab.

Here you’re going to use the dropdown arrow to select placeholders based on what information you want to show on your labels.

I’m going to start with “First Name”. When adding these placeholders you need to include spaces and commas like you would if you were typing out the address information directly into each label.

After you’ve added a space, select “Last Name”. Then hit the “Return” button on your keyboard and select “Street Address”. Again, hit the “Return” button and select “City” followed by a comma and a space. Next, select “State” hit the spacebar and select “Zip Code”.

Once you’ve finished selecting the categories you wish to include, click on step four. If you wish to filter which contacts and their mailing information you add to your document you can do so in this step. If you wish to upload all of the contacts in your mailing list, skip this “Filter Recipients” step.

Next, move down to step five or the “Preview Results” step. In this section you’re able to preview your mailing list. Choose the number of contacts you wish to add to your label template from your mailing list. If you want the document to show all of your contacts, click the button that looks like an arrow with a bar after it or if you know the number of contacts you have on your mailing list, type that number in the box provided.

Now, move down to step six. This is the “Complete Merge” step. Here, you’re going to click the “Merge To New Document” button. It may take a few seconds for your contacts to upload to your Microsoft Word template.

Once the contact information is uploaded you’re able to change the alignment of your contacts, add and edit information and also change the color and size of the font.

Using a basic mail merge makes uploading contacts and printing mailing address labels quick and easy!

Have you ever used the mail merge manager in Microsoft Word to print labels? Do you use the templates from SheetLabels.com when printing your labels? Share your answers on our Facebook and Twitter pages by using #SLIBlog!

Add a comment

Reasons to Love SheetLabels.com!

5 Star

AWESOME!

Quick service along with excellent product. Will continue to order from you!
Jennifer B.
5 Star

Fastest Service Out there - Quality Products

Our company has ordered numerous Labels from SheetLabels.com over the past few years. We have always received the labels on or before we needed them, they were quality labels, no matter which ones we ordered, and love the fact you can order the quantity you need no matter how small or how... read more
Judith Y.
5 Star

great service

gold foil round 12-up labels are great product & fast shipping; thank you!
Tom M.
View All Reviews
We Know Labels

We Know Labels

We can help you decide on the best material, or can even give you tips on how to improve your label print quality!

Fast Turnaround

Fast Turnaround

Get your labels as soon as tomorrow! Order today to enjoy our great prices and fast shipping.
Unmatched Quality

Unmatched Quality

We take pride in the high quality products that we offer. If we ship it, we guarantee it!

Sheet-Labels.com Spectacle Concept
© 2014-2016 SheetLabels.com® All rights reserved. Terms of Use | Site Map
7 Pruyn’s Island Drive, Glens Falls, NY 12801.
Privacy Policy