![mail merge labels word 2010 from excel mail merge labels word 2010 from excel](https://www.excelarticles.com/image/LE1495.png)
Once selected, > should appear on all tags. Go back to the ‘Emails’ tab and then click ‘Update Labels’. Once you’ve confirmed that everything is set up correctly, click “OK.”īack in the “Insert Address Block” window, check the preview to make sure everything looks right, then click “OK”. For example, “First Name” must match “First Name”, and so on. In the “Required for address blocking” group, make sure each setting matches the column in your workbook. In the “Insert Address Block” window that appears, click the “Match Fields” button. Select the first label, switch to the “Post” tab, and then click on “Address block”. Now it’s time to add your mail merge fields into Word labels. Step Four – Add Mail Merge Fields to Labels Your labels are now connected to your worksheet. Make sure to enable the “First row of data contains column headers” option if it isn’t already, and then click “OK”. If you have multiple sheets in your workbook, they will appear here. Use it to locate and select your mailing list archive. Back on the “Emails” tab in the Word document, select the “Select Recipients” option.Ī dropdown menu will appear. Step Three – Connect Your Worksheet to Word Labelsīefore you can transfer data from Excel to your labels in Word, you need to connect the two. Note: If the label outlines are not showing, go to Layout > Borders and select “View Gridlines”. Your label outlines will now appear in Word. Here, you can select your label brand and product number. Next, go to the “Mail Merge” tab and select “Start Mail Merge”.įrom the drop-down menu that appears, select “Labels”. Go ahead and save your list and let’s go to Microsoft Word. Once you’re done, your list should look like this: Once you’re done creating the headers, go ahead and enter your data. You can even insert images into mailing labels if you want, but that step would come later in Word. This is the standard information you’ll find on shipping labels.
#Mail merge labels word 2010 from excel code#
Our list will include the following headings:įirst name Last name Direction Town Condition Postal Code Also, if your listing is for businesses and not individuals, you can skip the “First Name” and “Last Name” header and choose “Company Name.” To properly illustrate the steps, we will use a personal mailing list in this example. Titles are always nice, but it’s important that you know what title a person is using before you create your tags. The headers you include will depend on the information you plan to use in your mailing labels. Put those headers in the first row of each column. The first thing you need to do is create a column header corresponding to the data that goes in each column. If you haven’t created the list yet, even though Excel doesn’t have the mailing label feature, we recommend that you use Excel, as it’s better at organizing and maintaining data than using a Word table.
![mail merge labels word 2010 from excel mail merge labels word 2010 from excel](https://www.dummies.com/wp-content/uploads/290642.image0.jpg)
If you have already created a mailing list in Excel, you can safely skip this test.
![mail merge labels word 2010 from excel mail merge labels word 2010 from excel](https://www.howtogeek.com/wp-content/uploads/2019/05/office_word_lede.png)
However, when you’re ready to print mailing labels, you’ll need to use mail merge to create them in Word from your Excel list.
![mail merge labels word 2010 from excel mail merge labels word 2010 from excel](https://i.pinimg.com/736x/42/1c/27/421c2791b52ae857d5bff6a8c7545f69.jpg)
You may be using Microsoft Excel to organize a mailing list in an orderly fashion.
#Mail merge labels word 2010 from excel how to#
How to create mailing labels in Word from an Excel list