Mailing Labels

[Guest]

Hi,

I'm trying to write VBA code that will allow me to print mailing lables in
Access. Here's an example of what I need to print:

School ID School Name # of mailing labels

223 Bunche Academy 37
346 Castlemont: BIT 134

I don't have the addresses in there yet, but as you can see, I need the code
to recognize that Bunche Academy needs 37 labels printed while Castlemont:
BIT needs 134 labels printed.

Can anyone help me out with this?

Thanks,

Antney

 

[Allen Browne]

See:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article explains how to use a simple query to generate a record for each
label, so the report prints the right number. No code needed.