This way you can make sure that the Labels are printing properly before you print all the other Labels.Īfter you print one page of Labels, and they look perfect (Hooray!) you can print the whole document and all your Labels. We recommend printing just one page of Labels to start. Now that you’ve done your mail merge and your Labels are setup correctly, the final step is to print them. Step 5 : Print Your Address Labels from Excel! Go to File > Save As, and then save the file to your desktop/mac. This is a good time to save your new Labels document. This last step will merge to new document and link your mailing address List with all your Labels.Īfter you select ‘Finish & Merge’, Word will open a new document, and you will see all your newly merged Labels! Every label will include your recipient information, with Names and Street Addresses, Cities and Zip Codes. The last step of the mail merge is to select ‘Finish & Merge’. This will select labels and update all your other Labels so that they match fields and the same format as your first Label. Once you’ve setup your first, new Label, then select ‘Update Labels’. Select ‘Address’, then hit Enter again, to move down to the next line.Select ‘Last Name’, then hit Enter to move to the next line of your Label.Select ‘First Name’, then use your space bar to add a space.Place your cursor in the top left hand corner of the first Label, then Select ‘Insert Merge Field’.The next step is to tell Word which Fields/Headers you’d like to use from your List. But we recommend doing it, because it’s a quick way for you to make sure that the correct List is now linked to your Labels. Selecting ‘Edit Recipient List’ is optional. Find the mailing address List that you want to use, then > ‘Open’.Select ‘Select Recipients’ then > ‘Use an Existing List’.To start your Mail Merge you’ll use the mail merge feature and follow these steps: In this step, we will connect your List in Excel to your Labels in Word. Now that you’ve organized your Labels in Word, the next step is to setup and perform the mail merge. It will look like this: Step 4 : Perform a Mail Merge Select ‘Mailings’ from the top navigation menu.Īfter you click Ok you will see the first sheet of your blank Labels setup on the screen.Open a new, blank Word document, click ok, then follow these steps: You can use a paid version of Microsoft Word, or download a simple free version called Microsoft 365. Now that you’ve got your mailing address list ready, the next step is to organize your Labels in Microsoft Word. Step 3 : Organize Your Address Labels in Microsoft Word Here are the most common items that are included on address labels from excel: You need to make sure that there is a designated Column and Header for each item that you want displayed on your Labels. The Headers are sometimes referred to as ‘column headings’ and they describe the contents of each column in your excel spreadsheet. When you open your Excel file List, the Headers are located in the first row. So, before you print labels from excel, you must double-check your column Headers and make sure they are all setup correctly. Regardless of if you purchase a mailing list, or if you create your own, your Mailing Address List in Excel must include correct Headers. If you want to grow your business and send an advertisement to prospective new customers, you can Buy a Mailing List online in an Excel worksheet format and then use that list to create mailing Labels from excel. Or, if you don’t want to use your own mailing list, you can purchase a list of Names & Addresses from a reputable data source. You can create your own mailing address list, using the Names & Addresses from your current Contacts/Customers. Once you’ve chosen your mailing address labels, the next step is to create address block labels in Excel. How to Print Labels in Excel – Avery Product Number 5160 Step 2 : Setup Your Address List in Microsoft Excel You can purchase Avery 5160 Address Labels online at Amazon or Walmart (to name a few), or in your local stationary store. If you’re looking for standard, white, peel & stick Address Labels (which look great on Postcards & Envelopes), we recommend using Avery 5160 Labels. Label options differ in color, size and shape. There are lots of different types of Address Labels to choose from.
0 Comments
Leave a Reply. |