How to Print Multiple Sheets of Different Label Information
Microsoft mail merge gives you the ability the print multiple sheets with different label information. Mail merge uses Microsoft Word and a data source. The data source is the list that provides the label information. This information can reside in a text file, Excel spreadsheet, Access database, or Outlook contact list. Once the mail merge has the data source and label information, they can be formatted and printed.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Word 2010 and click the "Mailing" tab. Click "Start Mail Merge." The Label Options dialog box appears. Click the label vendor and product number you are using for this project. Click "OK." A grid outline appears in the Word document.
-
2
Click "Select Recipients" and "Use Existing List." Browse the files and locate the Excel workbook. Click the workbook and select the "Open" button. The Select Table dialog box appears. Select the worksheet and click "OK."
-
-
3
Select "Insert Mail Merge." A drop-down list of fields appears. Use these fields for your labels. Select the first field and press the "Space" bar. Click the "Insert Mail Merge" field button and select the next field. Press the "Enter" key. Continue this until the first label has all the needed fields.
-
4
Press the "Preview Results" button to preview the label. Press "Update Labels" to format the remaining labels. Click "Finish & Merge" to print the labels. Select "All." The Print dialog box appears. Select the printer and add your label paper to the printer. Click "OK" to print the labels.
-
1
