MS Word 2003 Mail Merge with Excel (Labels)

1. First, ensure that the first row in your Excel worksheet is either blank or is a title row. The mail merge assumes that the first row IS NOT an address.
2. Open a new Word document and select Tools >> Letters and Mailings >> Mail Merge
3. Select the Label document type on the right menu bar and then click Next: Starting Document, located at the bottom.
4. Select the option to Change document layout and then click Label Options.
5. Select the correct Label product (i.e. Avery) and the correct product number. This can be found on your labels. Click OK.
6. Click Next: Select recipients at the bottom.
7. Select to Use an existing list and click the Browse link.
8. Locate the Excel file you wish to use and double-click on it.
9. On the Confirm Data Source window, select the option MS Excel Worksheets via DDE and click OK
10. Select Entire Worksheet and click OK.
11. Your list should appear in a window. Click OK.
12. At the bottom of the menu, click Arrange your labels.
13. Click the Address block link.
14. At the bottom of this window, click the Match Fields button.
15. Match each of the appropriate fields by clicking on the drop down list. Only match fields that you have entered in your Excel spreadsheet such as first name, last name, address, city, state, and zip code. Then click OK.
16. Click OK again and then click the Update all labels button.
17. At the bottom of the label, click Preview your labels.
18. Then click Complete the merge.
19. You are now ready to print. Click the Print link.
20. On the first pop-up menu, select All and then click OK.
21. On the print window, select All in the Page Range and click OK.