1. Make sure that your Excel spreadsheet has column
headings.
2. Do not leave any blank cells in row one. This is
very important. The merge will not work properly if there
is a blank cell in row one. If a certain column has no
column heading, then type xxx in the first row for the
heading of that column just for the sake of having
something there, so there are no blank cells in row one.
3. If you made any changes as a result of #2 above,
save, and close Excel.
4. In a blank document in Word, click on Tools/Mail
Merge.
5. Then click on Create under Main Document
6. Click on Mailing Labels from drop-down list
7. Select Active Window in the next dialogue box that
opens
8. Click on Get Data under Data Source
9. Click on Open Data Source.
10. In the Open Data Source, at the very bottom where
it says "Files of type", click on the down arrow, scroll
down and click on All Files (*.*)
11. Now locate the Excel file which contains the data
you want to merge to labels, and double-click on it.
12. Next dialogue box, click OK to "Entire Spreadsheet"
13. Next dialogue box, click on "Set Up Main Document"
14. In the Label Options dialogue box, select the type
of label you want to use and click OK
15. In the Create Labels dialogue which comes up next,
click on Insert Merge Field
16. Next dialogue box, click on Insert Merge Field and
select the first column heading of data you want to put in
the labels, i.e. Customer. Select each field (column
heading) as you want them to appear on the label. If
there is a column of data on the Excel spreadsheet that
you don't want to include, simply don't select it here
from this list.
17. Hit the Enter key after each field selection if
that is the end of the line on the address label. This
will move you to the next line. If you want more than one
field to appear on one line on the label, simply press the
spacebar, or a comma plus spacebar, or whatever, until all
your fields are showing in the "Sample label" section the
way you want them to print. For example:
«CUSTOMER»
«STREET_ADDRESS»
«CITY» «PROV» «POSTAL_CODE»
18. Click OK
19. Click on Merge. under "Merge the data with the
document"
20. Select New document under "Merge to"
21. Select All under "Records to be merge" (I've never
tried doing part of an Excel spreadsheet, as yet)
22. Select Don't print blank lines.. under "When
merging records"
23. Click on Merge
24. Congratulations! Your labels are created! Now
you can format them the way you want, i.e. larger font,
all caps, etc.
