multiple printer codes

[kurt]

In Word 2003, I've created a macro to select certain trays for paper type,
such as bond, draft, etc. My firm has multiple different printers, and I'd
like to have the macro automatically select a certain tray BASED on the
active printer. Is there an IF statement, for example, that I can use? i.e.
My button for selecting BOND paper would do something like the following: If
active printer=Mickey, tray3, if active printer=Minnie, tray 2, etc. I know
how to set up the VBA for the page setup and trays, I just need the piece for
the conditional statement for the printers.

THANKS so much for your help!

 

[Doug Robbins]

There certainly is an If...then...Else construction in VBA.

To get the name of the current printer, use Application.ActivePrinter
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP