HOW TO CREATE MAILING LABELS IN WORD FROM AN EXCEL DATABASE
presented by Joan Ramsay

---

01. Open Word 2002 or Word 2003.
02. Choose Tools/Letters and Mailings/Mail Merge
03. In right hand pane, choose Labels.
04. Click Label Options.
05. Click Next: Starting Documents (Step 1)
06. Select an appropriate label type (make, label size, page size) and print type (manual if feeding one page at a time; else default tray) and click OK. Example: 3261 or 5160
07. Click Next: Select Recipients (Step 2)
08. Select "Use an existing list". Click Browse and select the Excel database file.
09. Click Open. Select "Sheet1$" or the name assigned to the worksheet tab. Click OK.
10. A list of recipients will appear. All will be checked by default. If there are blank or zero-fill lines present click on the drop-down arrow next to Surname and select "Nonblanks".
11. Click the check box on records you do not want included in the labels.
12. Click OK.
13. Click Next: Arrange your labels (Step 3)
14. Click "More items"
15. Click the name of the first field to be included on the label (usually First Name), then click Insert.
16. Do this for all remaining fields in the order you want them to appear on the label. Do not format yet.
17. Click Close.
18. Format Label 1 containing the field names just inserted.
19. Press Enter for each new line, insert spaces between fields, add punctuation as required.
20. Click "Update all labels". (Scroll down if Step 4 is not visible).
21. Click Next: Preview your labels (Step 4) or click "Previous:" to return to Step 3 to reformat Label 1.
22. Click Next: Complete the merge (Step 5) when you are satisfied with the label format.
23. Click Previous: Preview your labels (Step 6) if you want to return to formatting the labels.
24. Else click "Print" to print the labels immediately.
25. Or click "Edit individual labels ..." if you want to save the label file for printing later.
---click "All" in the "Merge to New Document" window.
---click OK.
---click "File/Save as" and name and save the file where you can find it later.
End.