How can the print spool be controlled?

P

Pat M

I have a single page document that is used to print letter sized labels that
are placed on a 5-gallon pails. Each label has a formfield that is
incremented by a vba print procedure. This allow each pail to have a unique
pail number.

The problem is that each page ends up being a separate document to the print
spool. In a multi-user environment, this results in other uses print jobs
can be interspersed in my jobs.

Is there any way to hold the print spool open until my procedure is complete
and then release the entire job at once? How can I automatically print 200
copies of a one page document with a different page number on each copy
without generating separate print jobs?

My current work-around is to eliminate the vba code, and use page numbering
feature for the pail numbers. It bothers me that the document has to be
increased to 200 identical pages (except for the page number) to use this
solution.

Patrick
 

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

Top