Changing Printer Tray


Posted by Ryan on February 10, 2002 2:38 AM

Is there anyway of selecing the correct print tray when printing a doc using a macro? I have two tray printer and some docs need to go on letterhead where others go on plain. I have tried recording a tray change as part of the macro but nothing shows in the subsequent code. Thanks in advance.



Posted by Jack in the UK on February 10, 2002 8:28 AM

I never sorted this by code set the default to Manual or top / bottom and them save, i had 2 Excel to do thsi then print.. Pain but only fix i worked out HTH [NT]