How to print avery labels from excel list

#HOW TO PRINT AVERY LABELS FROM EXCEL LIST ZIP#

You can reduce the font size by choosing Table | Select Table to select all of the text in the entire document then, use the Font option on the Format toolbar to select the size font you want. By doing this, you can make sure that the layout arrangement fits on your labels. At this point, Mail Merge allows you to make final changes to your recipient list.ДЄs a matter of practice, you may want to print to a plain piece of paper before printing to your labels. You will see the live data populate the labels. You will see the fields you selected populate the labels.

Дњlick on the 'Update all Labels' button in the Mail Merge task pane.

When you have your labels arranged the next step is to replicate your labels.

#HOW TO PRINT AVERY LABELS FROM EXCEL LIST ZIP#

Furthermore, your city, state and zip could be contained in a single field. Your field headers may differ or you may have multiple Names fields to include. пѓј Select 'Street Address 2' and click on Insert. пѓј Select 'Street Address 1' and click on Insert. пѓј Select 'More Items' to redisplay the Insert Merge Field Dialog box пѓј Press your Enter key to drop to the next line in the label layout

NOTE: As you arrange your labels, you will need to close the Merge Field dialog box to insert any line breaks, commas, periods and spaces between fields. When you choose 'More Items' the Insert Merge Field dialog box will be displayed. Most likely, you will need to use the 'More Items' option to manually arrange your labels to suit your application.

There are some predefined arrangements but those work best when your data is highly conforming.

Дњlick on 'Next: Arrange your Labels' in the Mail Merge task pane.

You will see > indicators in each of the label boxes of your document except the first label where you will complete your label set up. You can also deselect certain records by eliminating the пѓј next to the record to be skipped. The column drop downs filter similarly to Excel's filtered list features by choosing certain criteria.

Дњlick on OK вЂ“ The Mail Merge Recipients dialog box will display, you can filter your data at this point to print all records or selected records as needed.

Make sure there is a пѓјin the 'First Row contains Column Headers' option, if it applies.

If your file contains only one worksheet containing data, this step will be confirmatory.

Select the worksheet containing the address data from the 'Select Table' dialog box.

The 'Select Table' dialog box will be displayed.

Click on Open, once you have located the Excel file containing your data.

Дњlick on Browse and navigate to where your Excel file is located on your system.

Place a tick mark in the radio button next to 'Use an Existing List'.

Дњlick on 'Next: Select Recipients' from the Mail Merge task pane.

If it is not, then position it there before you proceed with the next step.

Your insertion point should be displayed in the first label box of your document.

This is an optional step but I find it helps to see where things will position. This makes it easier for positioning your text.

Дњlick on the Show-Hide button on the Standard Toolbar to display the non-printing characters.

As soon as you click on OK, Word will apply the proper layout for the size label you selected to your document. The most common address label size is Avery 5660. Use that number to determine the correct layout of your label. Generally, the Avery Standard Label product number equivalent is stated on most on the shelf label products.

Дњlick on the link to 'Label Options' to select the size and layout of the labels you want to use.

Put a tick mark in the radio button next to 'Change Document Layout'.

Дњlick on 'Next: Starting Document' at the bottom of the Mail Merge Task Pane.

Put a tick mark in the radio button next to 'Labels' to indicate the type of document you want to create.

This menu selection will open the Mail Merge task pane on the right hand side of your screen.

With a blank document open, select Tools| Letters and Mailings | Mail Merge.

When you start your mail merge process, your Excel file may or may not be open the process will work in either case. Generally, I use one font size larger and a bold characteristic. It is also important that the row containing column labels be formatted differently from the data contained in the list. Any empty row signals the end of the list data and any data following the empty row will not be included in your label selection. Most importantly, your data list cannot contain any empty rows. You will have greater success if your Excel data conforms to Excel's criteria for list management. You have to use Word's Mail Merge feature and choose the Excel file as your source data. Excel does not have the capability to print labels directly from your Excel file.

How to print avery labels from excel list