You can print labels from Excel for multiple contacts directly in Microsoft Word. Follow this guide for how to import Excel addresses into Word labels using the Mail Merge feature to create.

Make sure that you have downloaded and installed Avery Wizard for Microsoft Word.

Start Microsoft Word. Click the Avery tab at the top of the Microsoft Word Ribbon toolbar and click the Avery Wizard logo

If you do not see an Avery tab at the top of the Microsoft Word Ribbon toolbar, click the Office button at the top left and then click the Word Options button. The Word Options screen will appear. Click Add-Ins and then select Word Add-Ins from the Manage drop-down list. Click Go. The Templates and Add-ins dialog box will appear. Check AVWiz12s.dotm and click OK. Close Microsoft Word, then re-open Word. The Avery tab should be added to the Ribbon toolbar. Click the Avery tab and then click the Avery Wizard logo to launch the Avery Wizard.

The Avery Wizard will open, click the Next button.

If you know your Avery product number, type in the product number in the Product number or description field. Click Search. Searching by product number is the fastest way to locate your product. The product number is usually shown as a four or five digit number in large print on the front of the package.

Or select a Product Category from the drop-down list. You can view products, in the product list, in order by Product No. or by Description. Click the Product No. Resolume plugins free download top ten free vst plugins for macac. column to sort the list numerically by product number or the Description column to sort the product names alphabetically. You can then scroll down the list to locate and select the product.

Select the product template and click Next.

Select a pre-design for your product template and click Next to start personalizing your template.

One benefit of using Microsoft Excel to create tables containing information such as the names and titles of employees or conference attendees is that you can use that table later as a data source for a mail merge in Word. You can also use this feature to create nametags and print them on perforated sheets or customize the size to suit your needs. The key is setting up the spreadsheet for the merge and then using the correct fields to import the data into Word.

Preparing the Worksheet

Step 1

Add headings to the Excel worksheet if the columns do not already have them. Your headings do not have to match Word's merge fields, but using functional headings such as 'First Name' and 'Last Name' will make the merge process easier.

Step 2

Delete any blank rows or columns within the data. Right-click on a blank row or column and select 'Delete.' Choose 'Entire Row' or 'Entire Column' and click 'OK.'

Step 3

Select the entire table. Click the 'Formulas' tab and click 'Define Name' in the Defined Names group. Enter a name for the list, such as 'Nametags,' and click 'OK.'

Performing the Merge

Step 1

Open Microsoft Word. Select the 'Mailings' tab and click 'Start Mail Merge' in the Start Mail Merge group. Choose 'Step by Step Mail Merge Wizard.' The Mail Merge pane opens.

Step 2

Select 'Labels' under Document Type and click 'Next.' Click 'Label Options' and choose the brand and product number if you are using commercial nametag sheets. Click the 'New Label' button to enter custom label dimensions. Click 'OK' to continue.

Step 3

Click 'Next' to select your data. Select 'Use an Existing List' and click 'Next.'

Step 4

Click 'Insert Merge Field' in the 'Write & Insert Fields' group on the Mailings tab. Click on the first heading that you want to appear on the nametags, such as 'First Name.' Insert all of the fields you want on the tags and format the fields as you want the text to appear, adjusting the font, size and alignment as needed. Click the 'Update All Labels' button to add the merge fields to all of the nametags.

Step 5

Click 'Next' to preview the nametags. Edit the tags as desired, then click 'Next' to complete the merge.

Step 6

Click 'Print' under Merge to print the nametags, or press 'Ctrl-S' to save the nametags to use in the future.