Microsoft Excel stores data for other Office applications to use. Microsoft Word makes address labels using its Mail Merge function, but an Excel document provides the source file. The programs work together, printing a series of labels using names and addresses from an Excel workbook. The label data needs its own worksheet, and Word handles the labels' layout.
- Skill level:
Other People Are Reading
Move your label data to a new, blank Excel workbook.
Insert a row on top off the sheet identifying the fields. If the labels specify first names, last names, street addresses and cities, for example, then name the rows "First Name," "Last Name," "Street Address" and "City."
Save the workbook as "Labels.xlsx."
Close Excel. Open Word.
Click "Start Mail Merge" from the "Start Mail Merge" tab in the "Mailings" ribbon.
Click "Step by Step Mail Merge Wizard" from the drop-down menu. The "Select document type" menu will open.
Select "Next: Starting document." Click "Use the current document."
Select "Next: Select recipients." Click "Use an existing list."
Click "Browse." Navigate to and select "Labels.xlsx."
Select the workbook containing your label data. Click "OK."
Click "Next: Write your letter."
Click the document. Click fields from the menu on the right. Arrange them on the document to form your label.
Click "Next: Preview your letters."
Click the "Preview your letters" section's arrow icons to scroll through the addressees.
Click "Next: Complete the merge."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for