Can you define a print driver for each person so it will print to their
specific bin.

Then you could put code in the templete to use that print driver using the
ActivePrinter property.

Otherwise, you have long row to hoe:

from a previous post:

Search Result 2
From: Tom Ogilvy )
Subject: Controlling two different printer trays
View: Complete Thread (2 articles)
Original Format
Newsgroups: microsoft.public.excel.programming
Date: 2003-07-13 21:47:34 PST


You have to use the Windows API to do it.

Here is a discussion on setting such as this:

http://www.microsoft.com/accessdev/a...0.htm?&gssnb=1

Regards,
Tom Ogilvy

-- Regards,Tom Ogilvy"Dottie" wrote in message
...
We have a template that is used by everyone at the office
and each person has a bin assigned to them on the printer.
Is there a way to create a macro so that this template
(document) will print out of the correct bin instead of
defaulting to the top bin?

We are using Windows 2000, and Office 2000.

Thank you in advance.