While you could tediously copy and paste names and addresses from a text document, with a little know-how in Excel, you can make the process far easier.

Before you create labels from Excel, you can select the Preview Results option from the Mailings tab to look over each individual label before you finalize the merge and print the entire selection.

With your labels created and ready to be used, it is now time to import the Excel spreadsheet information. There is no need to launch Excel to get this done, so for now, focus your time on Word.

You can take the information in a mailing label document and convert it to a column-based spreadsheet in Excel provided you you know how to prepare the document.

The second Excel drop down list will display the representatives in that region. To the right, you see labels and formats in preparation for creating the Excel drop down list.

I have names and addresses, etc., in an Excel 2002 spreadsheet and I want to use that information to print out address labels on the standard mailing labels (the sheets with 3 columns, and 10 rows.