Microsoft excel Labels

Question

i have alot (over 500) names/ adresses typed on microsoft excel and they need to be made into labels for microsoft word so i can print them. how do i do this??

Answer 1

Much too much to detail here, but I would point you toward Mail Merge in Word.  With versions of Word prior to Word Vista (2007), this would be found in the Tools->Letters and Mailings->Mail Merge Wizard menu item.

Some tips:

1. For the most flexibility with the mail merge fields in Word, keep first and last names in separate cells. Ditto for the parts of the address (street address, city, state, zip).

2. Before wasting pages of labels, run tests on regular paper and hold the sheets up against the labels to check the layout.

3. Don't leave the setting up to the last minute. Mail Merge can be frustrating and take more time to set up than one would think.

4. For test runs, use only enough names to be sure you're not losing any -- a little over a page should do. Accidentally skipping every other name is real easy to do.

Keep a sense of humor while you're wrestling with it.  It will be worth it the second time around.

Hope that helps.