how do you make mailing labels from an excel spreadsheet

To do this, click the “Customize Columns” button on the bottom left of the pop-up window.Įnter in your data, pressing the tab button between every entry to continue to the next field. You need to remove those fields before adding your own.

If you look at the field labels at the top, you may notice that it has labels for things the data did not include. When you click Next, a new window will pop up where you enter your data. You can also start from scratch when you click on “Type a new list” in the Select recipients group. If you had already opened a list, you could also edit it from here. You can also use Outlook contacts if you have it. If you’re using an existing list (usually one from an Excel file, but there are many other data types from which Word can extract data), you would choose “Browse” under Use an existing 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 do you make mailing labels from an excel spreadsheet