Print multiple mailing labels in Access 2003 or 2007

[Patrick Sewell]

From: "Patrick Sewell" <[email protected]>
Subject: Print multiple mailing labels in Access 2003 or 2007
Date: Wednesday, November 28, 2007 3:45 PM

I have come across the following KB from Microsoft that has helped me to
print a fixed number of copies of the labels that I wish to print. This
works pretty well.

http://support.microsoft.com/kb/299024

However, I would like to include a field in my table for the number of
copies I want of each label. For example, if each record in my table
contains the information for a given label, one field in that record should
contain the number that represents how many of that type of label I want to
print. Each record may contain a differnt number in this field. I want all
records to print the appropriate number of times when I print the label
report.

How can I modify the code in the above KB to make this happen? Let's assume
that the table is named MyTable and the label report is named MyLabels and
the field in MyTable that contains the number of copies is called Quantity.

Any assisntance is greatly appreciated!

Thanks!

Patrick Sewell
(e-mail address removed)12.co.us
Network Administrator
Monte Vista School District
Monte Vista, Colorado USA

 

[John W. Vinson]

However, I would like to include a field in my table for the number of
copies I want of each label. For example, if each record in my table
contains the information for a given label, one field in that record should
contain the number that represents how many of that type of label I want to
print. Each record may contain a differnt number in this field. I want all
records to print the appropriate number of times when I print the label
report.

One trick you can use is to include a handy auxiliary table in your database -
I put one in all of mine. You can name the table Num, with one primary key
long integer field N; fill it with values from 0 to 10000 or so (you can use
Fill... Series in Excel and copy the spreadsheet into your table).

Base your label report on a Query including the Num table, with *no* join
line. Instead, put a criterion on N of

< [HowMany]

where HowMany is the field indicating the desired number of labels. This will
generate multiple copies of the record for printing.

You can even put a textbox on the label with a control source of

=N + 1

to show (e.g.) "Label 12 of 25".

John W. Vinson [MVP]