how to print address labels from excel mailing list

This is the important part of Mail Merge. Since we’re starting from scratch, we chose, “Use the current document.”Ĭlick Next: Select recipients Enter Your Data If you already had something you wanted to use, select either of the second or third options. In this instance, we’ve selected “Labels.”Īfter you click Next, you have three choices.

Choose the type of document you want to create.

When it starts, a new pane will open on the right of your Word screen. Now we can begin using the Mail Merge wizard.

Publisher – 37 Ink, Atria Publishing Group Gather Your Dataĭouble check that you have an Excel document ready with addresses, or add these examples we will be using: 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. If you’re like us, you use Excel for a lot of things.

How to print address labels from excel mailing list