PDA

View Full Version : Selecting paper tray before print



Agent Smith
12-05-2019, 09:00 AM
I find this easy to do in access but cannot figure out how in word. I use the code below to print the current page. How can I make it select a particular paper tray?


ActiveDocument.PrintOut Range:=wdPrintCurrentPage

gmayor
12-06-2019, 06:26 AM
See http://www.gmayor.com/fax_from_word.htm which includes code for selecting trays. However if you know the name of the tray you should be able to call it by name. The following certainly works with my Canon printer


Dim sTray As String
sTray = Options.DefaultTray
Options.DefaultTray = "Rear Tray"
Application.PrintOut Range:=wdPrintCurrentPage
Options.DefaultTray = sTray

Agent Smith
12-06-2019, 08:26 AM
Many thanks. Once I found the correct paper tray names that code worked perfectly.