I would like to use Excel to create address labels that can be printed on stickers. How to do it?

Question

Avery J 8560 or similar paper

Answer 1

Usually, this is done by creating a mailing list in Excel and using Word's Mail Merge feature to print the labels. Far too much to go through here, so I'll just give a few 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. Word's Mail Merge can be found in the Tools->Letters and Mailings menu item.
3. Before wasting pages of labels, run tests on regular paper and hold the sheets up against the labels to check the layout.
4. 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.
5. For test runs, use only enough names to be sure you're not losing any -- a little over a page should do. Skipping every other name is really easy to do.

Keep a sense of humor while you're wrestling with it.

Answer 2

Go to the Avery website and download the template for that label. It is the best way.

Answer 3

you do no longer prefer mail merge it incredibly is for putting addresses right into a letter. circulate to kit, Labels/Envelopes and %. your label, it is going to format the addresses into the label length. you may could tweak it some to get it in simple terms perfect, yet this is the 1st step besides.

Answer 4

Use Word in conjunction wiht Excel