Create multiple mailing labels on one page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is an Access 2000 question, and I can't quite find another posting along
these lines.

I have a table called Preappeal Data Input with the following fields:
Appellant Name, Appellant Address, School Name, School Address, Educational
Agency Name, and Educational Agency Address.

I created a query for the mailing labels, then used the wizard to create the
label. It prints one label per page for Appellant Name and Appellant
Address. The label I use has 3 across. How can I get 3 labels of Appellant
Name and Appellant Address to go across? Then on the next line, I want 3
labels of School Name and School Address .. what steps do I take to
accomplish that? Do I need to do a subreport?

Thank you for helping a frustrated end user .. I'm sure the answer is really
easy and I'm just overlooking it.
 
Remove the columns from your report and set the detail height to be twice
its current height. Then create and copy (twice) text boxes of the
addresses.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Label Wizard does not allow me Selection Criteria 0
Footer in labels 3
Multiple mailing labels single record 3
Multiple Numbers on ONE Label 8
Windows 7 8160 labels on windows 7 1
Design a report with verticle information instead of horizontal 2
Page Setup with VBA 1
Print multiple mailing labels in Access 2003 or 2007 2

Back
Top