USE
CODE
FREESHIP
ON
ORDERS
$55+
Welcome back!
Please sign into your account
Forgot password?
Don't have an account? Sign Up
← Back to blog

Print Mailing Address Labels & Using The Microsoft Word Mail Merge Manager!

Posted by Sheetlabels.com on 7/26/2014
Sheet Labels 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 “Printing Label 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!

Need help? We’re here!

Our expert customer service team is ready to help you with any questions or concerns you may have. Real time help is available Monday through Friday 9AM - 6PM EST
Contact