How to Make Labels From a List

Make address labels using a simple spreadsheet address list.

If you have a large list of addresses you need to make labels for, individually copying and pasting them into a label template can be hard work. Luckily, there is a simple way to make labels from a list. All you need is a few software tools, your list of addresses, and a few minutes.

Things You'll Need

• Microsoft Excel
• Microsoft Word

Instructions

1. Open Microsoft Word and click Tools, then Letters and Mailings, then Mail Merge Wizard, from the menu bar. The wizard window should open.

2. Click "label options" in the Mail Merge Wizard and enter in details about the labels you want to make. Finish by clicking "OK." Enter the label size that you will be printing and click "OK" when done. Under "Select Recipients," click "Use an Existing List."

3. Select the list file made in Microsoft Excel from your hard drive. Refer to the references for detailed steps on how to do this. Highlight the file and click "Open." You will be prompted to select the correct table from your file. Highlight the table and select. Before moving on, ensure you have the "First Row of Data Contains Column Headers" box checked. Click "OK."

4. Click through the rest of the Wizard's steps, until you get to "Print or E-mail." Select print. Pick the page size, your connected printer, and the paper type in the printer window. Click "Print" when ready.

References

• Microsoft.com: Print labels by using Excel data in a Word mail merge