To create a batch of labels, here's what you need to do:Ĭhoose 'See the labels as they will look printed' if you want to look at the finished product in Print Preview mode, or 'Modify the label design' if you want to change it in Design view first. For more information, check out Word 2007: The Missing Manual. Word includes a mail merge feature that can extract data from an Access database, and then use it to generate any document you want. Instead, you'll do better using a real word processing program like Word. Getting Access to cooperate isn't all that easy. Tip: If you have a database that stores information about people, then you may have thought about using Access reports to build form letters and other documents.

All you have to do is print, peel, and stick. You give Access the Avery number, and then it can create a report that puts the address information in the correct place. But no matter what type of label paper you pick, it has a standard Avery number that tells Access everything it needs to know about the labels' size, and how they're arranged. Label paper variessome types pack the information in very tightly, so you can print out dozens of return addresses at once, while others use larger labels for putting the mailing address on a letter or package. To make this work, you just need to buy a few sheets of label paper from your favorite office supply store. The Label wizard pulls address information out of any table you want and uses it to print out handy mailing labels.

If you have a table with address information (like customer homes, business locations, or suspected UFO sites), Access has another wizard to offer you.