How To Import Excel File Into Avery 5160 Template

You may be using Microsoft Excel to organize a mailing listing neatly. However, when you become set up to print mailing labels, you'll need to use mail merge to create them in Word from your Excel listing. Here's how.

Pace One: Gear up your Mailing Listing

If you have already created a mailing list in Excel, then yous can safely skip this test. If you haven't created the list nevertheless, despite Excel's lack of the mailing label function, we yet highly recommend you use Excel since it's improve for organizing and maintaining data than using a Word table.

The beginning thing yous demand to exercise is create a column header respective to the data that goes in each cavalcade. Place those headers in the first row of each column.

Which headers you include depends on which information you plan to utilize in the mailing labels. Titles are always prissy, but it'due south important that you lot know which title a person goes by before creating the labels. Also, if your listing is for companies and not individual people, you can omit the "First Proper noun" and "Last Proper name" header and simply go with "Company Proper noun" instead. To properly illustrate the steps, we'll go with a personal mailing list in this instance. Our listing will include the following headers:

• Kickoff Name
• Last Proper name
• Street Address
• City
• State
• Null Code

This is the standard information you'll discover on mailing labels. You can even insert images in the mailing labels if you want, but that step would come later in Give-and-take.

RELATED: How to Create and Print Labels in Give-and-take

Once you've finished creating the headers, get ahead and input the data. Once you're finished, your list should await something like this:

Become ahead and save your list and allow's head over to Microsoft Word.

Step Two: Set Up Labels in Word

Open up up a blank Word certificate. Next, head over to the "Mailings" tab and select "First Mail Merge."

In the drop-downward carte that appears, select "Labels."

The "Label Options" window will appear. Here, y'all can select your label make and product number. In one case finished, click "OK."

Your label outlines will now appear in Word.

Note: If your label outlines aren't showing, go to Pattern > Borders, and select "View Gridlines."

Step Three: Connect your Worksheet to Word's Labels

Before y'all tin can transfer the data from Excel to your labels in Word, y'all must connect the ii. Back in the "Mailings" tab in the Discussion document, select the "Select Recipients" option.

A drop-down menu will announced. Select "Use an Existing List."

Windows File Explorer will appear. Use it to locate and select your mailing list file. With the file selected, click "Open."

The "Select Table" window will appear. If yous take multiple sheets in your workbook, they'll appear here. Select the one containing your list. Make sure to enable the "Outset row of data contains column headers" option if information technology's not already and then click "OK."

Your labels are at present connected with your worksheet.

Pace Iv: Add together Mail Merge Fields to the Labels

Now it'due south fourth dimension to add together your post merge fields in Word's labels. Select the first label, switch to the "Mailings" tab, and so click "Accost Block."

In the "Insert Address Block" window that appears, click the "Match Fields" button.

The "Match Fields" window will appear. In the "Required for Address Block" grouping, brand sure each setting matches the column in your workbook. For example, "First Name" should friction match with "First Name," and so on. Once y'all've confirmed everything is set properly, click "OK."

Back at the "Insert Address Block" window, check out the preview to make sure everything looks good so click "OK."

<<AddressBlock>> will now appear in your offset label.

Caput dorsum over to the "Mailings" tab and so click "Update Labels."

One time selected, <<AddressBlock>> should appear in every label.

Now, you're now ready to perform the mail merge.

Step Five: Performing the Mail Merge

At present to watch the magic happen. On the "Mailings" tab, click "Cease & Merge."

From the drop-downwardly menu that appears, select "Edit Private Documents."

The "Merge to New Document" window will appear. Select "All" and then click "OK."

Your list from Excel will now be merged into the labels in Give-and-take.

All that's left to do now is print out your labels and send out your mail!

How To Import Excel File Into Avery 5160 Template,

Source: https://www.howtogeek.com/413665/how-to-create-mailing-labels-in-word-from-an-excel-list/

Posted by: manninosumanducke.blogspot.com

Share this post