{"id":2834,"date":"2012-02-18T13:37:21","date_gmt":"2012-02-18T21:37:21","guid":{"rendered":"http:\/\/www.podfeet.com\/wordpress\/?page_id=2834"},"modified":"2017-07-31T14:51:05","modified_gmt":"2017-07-31T21:51:05","slug":"how-to-make-mailing-labels-using-word-2011","status":"publish","type":"page","link":"https:\/\/www.podfeet.com\/blog\/tutorials-5\/how-to-make-mailing-labels-using-word-2011\/","title":{"rendered":"How to Make Mailing Labels Using Word 2011"},"content":{"rendered":"<p>&nbsp;<\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonSummary\">\n<p>These quick instructions will show you how to use a Word file containing addresses to make mailing labels<\/p>\n<p>Assumptions:<\/p>\n<ul>\n<li>You&#8217;re running Office 2011 for Mac<\/li>\n<li>You have a comma delimited file with the same number of fields in each address<\/li>\n<li>You have already purchased, or plan to purchase labels that match one of the options in Word labels<br \/>\n<!--more--><\/p>\n<\/li>\n<\/ul>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Your Address File<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329600047231.png\" alt=\"media_1329600047231.png\" width=\"513\" height=\"209\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>In the first row you need to put the names of each of the fields you&#8217;ll want to identify, e.g. Name, Address, city, state, and zip. Note that I have 5 fields in each address, the title row is separated by commas and each address row also has 5 records separated by commas.<\/p>\n<p>Close this file.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Open a Blank Word Document<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599765842.png\" alt=\"media_1329599765842.png\" width=\"540\" height=\"262\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Select Mail Merge Manager from the Tools Menu<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599788931.png\" alt=\"media_1329599788931.png\" width=\"540\" height=\"499\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">The Mail Merge Manager<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599808327.png\" alt=\"media_1329599808327.png\" width=\"242\" height=\"485\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>We&#8217;re going to simply step through each part of the manager.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Select Document Type<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599823354.png\" alt=\"media_1329599823354.png\" width=\"273\" height=\"183\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Use the Pulldown under step 1 &#8211; Create New, and select Labels<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Select Your Label Type<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599839678.png\" alt=\"media_1329599839678.png\" width=\"540\" height=\"313\" \/><\/div>\n<div class=\"StepInstructions\">\n<ol>\n<li>Find the label manufacturer<\/li>\n<li>Select the product number (will be printed on the label box<\/li>\n<li>Review the dimensions and verify from the box<\/li>\n<li>Click OK<\/li>\n<\/ol>\n<p>Note that even off brands will say something like &#8220;equivalent to Avery 5160&#8221; so you don&#8217;t have to buy one of the big brands.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Records Showing in Word<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599858471.png\" alt=\"media_1329599858471.png\" width=\"540\" height=\"312\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Word will lay out the labels for you as shown<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Open Your Address List<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599876221.png\" alt=\"media_1329599876221.png\" width=\"226\" height=\"280\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Under Step 2, Click the pulldown for Get List, and choose Open Data Source<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Select Your Address List<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599890186.png\" alt=\"media_1329599890186.png\" width=\"540\" height=\"399\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Add the Fields You Want to Print<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599907849.png\" alt=\"media_1329599907849.png\" width=\"540\" height=\"376\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>This is where you will select the fields you want to print, the order in which to print them and how they will be displayed<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Choose the Fields<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599922323.png\" alt=\"media_1329599922323.png\" width=\"450\" height=\"345\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Use the Insert Merge Field to choose the Name<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">All Fields Selected<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599950830.png\" alt=\"media_1329599950830.png\" width=\"447\" height=\"321\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Keep adding fields, using the enter to separate lines, and commas to separate city\/state and space or comma before zip. click OK<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Review Fields<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599962544.png\" alt=\"media_1329599962544.png\" width=\"540\" height=\"308\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Review the fields on the page to verify that they are as you expected<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Merge to New Document<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329599991097.png\" alt=\"media_1329599991097.png\" width=\"242\" height=\"508\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>As tempting as it is to stick your highly priced labels into the printer and click Print under Complete Merge, don&#8217;t do it. I promise you something will be wrong and you&#8217;ll have wasted money.<\/p>\n<p>Instead click the second button to Merge to New Document<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Review Labels<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.podfeet.com\/wordpress\/wp-content\/uploads\/2012\/02\/media_1329600005631.png\" alt=\"media_1329600005631.png\" width=\"540\" height=\"311\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>This creates a new document with your labels. I always print this on plain paper and hold it up to a bright light with the real label paper behind it to make sure no one&#8217;s address slops over a line. This can often happen with long addresses, or where a husband and wife have two different names. I like to correct these before printing.<\/p>\n<p>After circling back to this point and getting an acceptable print, you are free to stick your highly priced labels into the printer and simply print as you would any other document.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; These quick instructions will show you how to use a Word file containing addresses to make mailing labels Assumptions: You&#8217;re running Office 2011 for Mac You have a comma delimited file with the same number of fields in each address You have already purchased, or plan to purchase labels that match one of the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":4374,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[],"tags":[150,9],"class_list":["post-2834","page","type-page","status-publish","hentry","tag-mac-tutorials","tag-tutorials","post"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages\/2834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/comments?post=2834"}],"version-history":[{"count":5,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages\/2834\/revisions"}],"predecessor-version":[{"id":12369,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages\/2834\/revisions\/12369"}],"up":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages\/4374"}],"wp:attachment":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media?parent=2834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/categories?post=2834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/tags?post=2834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}