How to Get Names From Excel Into Labels in Microsoft Word

Transferring data from your Excel worksheet doesn't have to be laborious. With Word's mail merge, you can customize your labels and specify the exact data you want to extract from Excel. If you're making a name badge or table tent for a meeting, you can include the merge field for each recipient's name. To make your labels stand out, you can also bold, enlarge and highlight each name. Your format will be applied to each label.

Instructions

1

Open a new document in Word. Then choose "Mailings," "Start Mail Merge" and "Step by Step Mail Merge Wizard" from the Ribbon. The "Mail Merge" task pane will open.

2

Choose "Labels" as your document type, and click "Next: Starting document."

3

Choose "Use the current document" and click on "Label options..." The "Label Options" dialog box will open, where you can select the type of labels you want to use.

4

Click "OK" once you've chosen your label settings. Then click on "Next: Select recipients."

5

Choose "Use an existing list" and click "Browse." The "Select Data Source" dialog box will open. Find and double-click the Excel file you want to use. Then choose the correct worksheet from the "Sheet Table" dialog box and click "OK." The "Mail Merge Recipients" dialog box will load.

6

Pick the recipients you want to retrieve and click "OK."

7

Place your cursor in the first label on your page. Then return to the task pane and select "Next: Arrange Your Labels."

8

Click on "More items." The "Insert Merge Field" dialog box will open. Double-click the field containing the recipient's name to add it to your labels. If there's a second field for the person's last name, double-click it as well. Then press "Close."

9

Return to your page and insert a space after the recipient's first name if you have a separate field for the last name. To modify the text, select the fields on your page, then change the font, style and text size.

10

Return to the "Mail Merge" task pane and select "Update all labels." The remaining labels on your sheet will be replicated to match the first label.

11

Select "Next: Preview your labels" and "Next: Complete the merge." Then click "Edit individual labels." The "Merge to New Document" dialog box will appear. Choose "All" and click "OK."