Access® 2007 For Dummies®

Chapter 19. Magical Mass Mailings

In This Chapter

• Creating labels quickly and easily

• Formatting labels for specific situations

The Report Wizard (covered in Chapter 16) is just the tip of the Access report iceberg. If you're so inclined, you can use Access to generate useful printouts that you probably never thought of as reports — mailing or product labels. Don't be scared, though — we're off to see the wizards again, as Access provides friendly and magical helpers to see you through.

Massive Mailings with the Label Wizard

So you have 5,000 catalogues, newsletters, or some other mailable item printed and ready to go out to your adoring (or soon‐to‐be adoring) public. You also have a big Access database full of names and addresses. How can you introduce these two and get them started on what will surely be a wonderful relationship?

With the Access Label Wizard, your sheets of labels and your database will be married in no time flat. With the Label Wizard, you can quickly and easily generate labels that will work with just about any commercial label product on the market. If your local stationery or office supply store carries them, Access can print your data on them. All you need to know is what kind of label you have, which data should go on the labels, and who's going to slap the labels on the mailings after you've finished your part of the job.

When it comes to labels, names and addresses are just part of the story. You can also print product labels, with product names, numbers, and ...