How to Print Labels With Different Information on One Sheet

Printing labels with different information on one sheet can be done by using mail merge.

Using labels for your mailing can make your information look uniform and orderly. Labels can be purchased with designs on them or you can format them for your needs using software. Printing labels with different information on one sheet can be done in different ways.



The most obvious way is to manually change each label one by one. This can be a time-consuming project especially if you have hundreds or thousands of labels. Using mail merge can resolve this issue by importing a data source into a label document. This can print labels with different information on one sheet.

Instructions

1. Save your information for your label in Excel. Excel will serve as your data source. Make sure your information has column headers. You will need these headers when you format your label in Word.

2. Open Word and click the "Mailing" tab. Select "Start Mail Merge" and click "Labels." Update the printer information, label vendor and product number. Click "OK." Click "Select Recipients" from the Ribbon and "Use existing list." Change your file type to "Excel file" and browse your computer for the Excel spreadsheet you saved with your information.

3. Populate your label by using the "Insert Merge Field" button. Add fields to your label and format them as necessary. Press the "Enter" key to advance to a new line. Once you have added your data to your label, click the "Preview Result" button. This will show you how the printed labels will look with different information on each label. Click "Update Labels" to populate the rest of the labels your sheet.

4. Complete the mail merge by clicking on "Finish & Merge." Select "Individual Documents" and "All." Your finished merge document will open so you can print it or save it for later.

References

• Microsoft Office: Word mail merge: A walk through the process