Create labels in Word using data from Discoverer
| Steps | Screenshots |
|---|---|
Step 1Open MS Word On the Tools menu, select Letters and Mailings and then select Mail Merge which opens the Mail Merge task pane on the right side of the screen. |
![]() |
Step 2At the top of the task pane, under Select document type, select Labels Under Step 1 of 6 at the bottom of the task pane, click Next: Starting document
|
![]() |
Step 3To set up a new label main document, under Select starting document, select Change document layout. (When you open Word, a blank document opens by default. That default document does not have a label layout. To create labels, you will need to change the layout of the default document to a label layout). |
![]() |
Step 4Under Change document layout, click Label options... It is here that you will select:
|
![]() |
Step 5In the Label Options dialog box, click the printer type (either Dot matrix or Laser and ink jet) (Central Stores supplies Universal 80102 which is the equivalent to the Avery 5160) Select the appropriate Label products: by clicking on the down arrow. In the Product number: box, select a label type similar in size to your labels. Click the OK button in the Label Options window. A blank label layout is displayed Under Step 2 of 6 at the bottom of the task pane, click Next: Select recipients. |
![]() |
Step 6Under Select recipients, select Use an exiting list and then click on Browse In the Look in list, click the folder in which you saved the workbook with your data, click the workbook, and then click Open.
|
![]() |
Step 7In the Select Table dialog box, locate and click to select your list. Make sure the First row of data contains column headers (located in the lower left hand corner) check box is selected, and then click OK. |
![]() |
Step 8In the Mail Merge Recipients dialog box you have the opportunity to filter or sort the entries in the data file.
To eliminate a recipient, click the check box at the beginning of the recipient’s row to clear it. If you are going to create labels for all the recipients in your data file, and don’t need to do any filtering or sorting, click OK |
![]() |
Step 9Under Step 3 of 6 click on Next: Arrange your labels.
|
![]() |
Step 10In the Insert Address Block window, Specify address elements for your labelsClick the Match Fields… button Select the fields that you want to appear in the address block by clicking on the drop-down arrow for each field and when done, click OK (you can also remove any unwanted fields by clicking on the drop-down arrow and selecting (not matched)) Click OK again to close the Insert Address Block window.
|
![]() |
Step 11Under Replicate labels, located in the middle of the task pane, click Update all labels to copy the layout of the first label to the other labels.
|
![]() |
Step 12Several of the merged labels are now displayed. You can preview individual labels or make changes to the recipient list by clicking on Find a recipient… under Preview your labels or Edit recipient list… under Make changes. Under Step 5 of 6 click Next: Complete the merge |
![]() |
Step 13Under Merge, you have two choices:
|
![]() |
Step 14To print:
|
![]() |
Step 14To edit individual labels: Click Edit individual labels… to create a new document with all the merged labels. (Do this if you want to review the labels more thoroughly before you print the final labels, or if you want to make custom changes to specific labels.) If you want to save the file for future use, in the Merge to New Document box, to merge all records to a new document be sure that All is selected, click OK. A new label document will appear. You can now save the file for future use. |
![]() |
Return to Documentation Page »

















