It’s up in the upper left corner if you save your documents on OneDrive or a SharePoint server. Open your Word program and click on the Mailings Tab. We’ll start from Word and the following instructions should work for Word 2010 on up. We’re going to make labels for envelopes with the following information: Let’s pretend we want to send out query letters to a few publishers for your great American novel. Collect this data in your Excel spreadsheet, or create a list within Word. The first thing to know about creating a successful Mail Merge is what you are going to be creating, and to whom will you be sending it. Note: In addition to labels, you can import your address list into Google Maps to create a map of sales leads, customers, friends, or other contacts. We’ll describe just one of the easy ways to create labels with Mail Merge. For instance, there are many ways to start the Mail Merge process. Assuming you already have that Excel document with your list of friends, customers, leads, or other contacts, you are ready to go.Īs with all things Microsoft, there is more than one way to accomplish what you need. Excel also helps you prepare your list of names and addresses in a structured way so you can easily print them on address labels. Even if you have another contacts list, such as Google Contacts, you might find yourself exporting to Excel so you can easily view, sort, and filter. Use the Microsoft Word's Find and Replace formatting tool to replace all the pre-designed template text in each label with your own information.If you’re like us, you use Excel for a lot of things.Continue with Step 3 until all labels are filled with your information.Position the cursor in the next label, right-click and select Paste.Highlight all the content in the first label, right-click and select Copy.Insert your information on the 1st label.How to create a sheet of all the same labels: Then click Text Wrapping and select In Front of Text in the drop down list. Select your image in the template and click the Page Layout tab in the Ribbon Toolbar. Highlight the text you entered and use the tools in Microsoft Word to format the text.Ĭlick the Insert tab in the Ribbon Toolbar to insert your own image, clip art, shapes and more. Once the file is open, type your information into the template. If the template looks like a blank page, select Table Tools > Layout > Show Gridlines to view the template layout. Double-click the Avery Word Template file you downloaded and saved to your copmuter.

How to print name labels from word