LABEL WIZARD HOW TO

You simply need to open your report in Design view, make sure your detail section's very narrow (see Chapter 11), and then choose Report Design Tools Page Setup Page Layout Columns. You can create your own report that also uses multiple columns to put records in a grid. (Usually, the Detail section's copied in one direction only: down the page.) This method gives you a tightly packed grid of labels. That way, the Detail section (which represents the label) can be copied from right to left across the width of the page, and then down the page.

The only difference between label reports and ordinary reports is that label reports use multiple columns. The Detail section contains a template that defines how Access places the fields for a single label, and that template's copied across the form. The label report's really just an ordinary Access report, like the kind you've learned about throughout this chapter. (You could place a company logo in the corner of the address, and so on.)ДЇigure 11-15. If you open it in design mode, then you can add extra touches. ДЄccess saves your report, and then opens it in print preview mode (Figure 11-15) or design mode, depending on your choice. 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. In the drop-down menu that appears, select вЂњ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. Next, head over to the вЂњMailingsвЂќ tab and select вЂњStart Mail Merge.вЂќ Go ahead and save your list and letвЂ™s head over to Microsoft Word. Once youвЂ™re finished, your list should look something like this: Once youвЂ™ve finished creating the headers, go ahead and input the data.

LABEL WIZARD HOW TO

RELATED: How to Create and Print Labels in Word You can even insert images in the mailing labels if you want, but that step would come later in Word. This is the standard information youвЂ™ll find on mailing labels. Our list will include the following headers: To properly illustrate the steps, weвЂ™ll go with a personal mailing list in this example. Also, if your list is for companies and not individual people, you can omit the вЂњFirst NameвЂќ and вЂњLast NameвЂќ header and just go with вЂњCompany NameвЂќ instead. Titles are always nice, but itвЂ™s important that you know which title a person goes by before creating the labels.

Which headers you include depends on which information you plan to use in the mailing labels.