How to Print Labels From Excel First, you must create a properly formatted contact list in an Excel spreadsheet.

After purchasing labels whose dimensions resemble those of nametags you can let Word use your Excel data to create nametags automatically.

To create labels in Word from an Excel list, open a blank Word document > select Mailings > Start Mail Merge > Labels > choose the brand and product number for the labels.

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 ...

Bet you didn’t know Excel could do: graph paper, address labels, award certificates Excel does just as well as Word in creating and customizing these useful office supplies. Here's how.

Microsoft Word has a date field, but it's not easy to use in an expression. If you need to update dates in a document, use Excel to calculate the dates and then run a mail merge.