How to set print priority in VBA?

[Peter Campbell]

Is there a way to set the print priority in VBA? When
printing a large number of sorted files in a batch print
and the spooler gets filled, the documents quit printing
in sorted order.

 

[Doug Robbins - Word MVP]

Hi Peter,

Try setting the Background property of the PrintOut method to False

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Peter Campbell]

I have already set the Background property of the
PrintOut method to False. I believe the problem is that
when the Windows print spooler gets filled the order in
which the documents were sent to the printer is no longer
automatically followed. I know I can set print priority
by going directly to the spooler and individually setting
it by document but that defeats the purpose of a batch
print of all documents in a folder. What I am wanting to
do is set it in VBA at the time the code is executed and
still have it printed in sorted order even when the
spooler gets filled. I am printing between 80-100
documents at a time. Thanks for any help.

 

[Doug Robbins - Word MVP]

Hi Peter,

From the Start menu select Printers and Faxes and select the printer and
right click on it and select Properties. Then on the Advanced tab. uncheck
the "Spool print documents so program finishes printing faster" item.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP