hello,
i need to setup a macro (in word2007) which allows me to print to a non-default printer and so that page 1 prints in tray 3 and the remaining pages print to tray 4 (headed and continuation paper)
I've found this macro:
which seems to work fine for 1 tray, but i think i need to amend it somehow with the following:Code:Sub HPPrintTray2() Dim sCurrentPrinter As String Dim sTray As Integer sCurrentPrinter = ActivePrinter sTray = Options.DefaultTrayID ActivePrinter = "HP LaserJet 4050 Series PS" With Options .DefaultTrayID = 260 End With Application.PrintOut FileName:="" With Options .DefaultTrayID = sTray End With ActivePrinter = sCurrentPrinter End Sub
can anyone show me how to successfully combine the two?!Code:.FirstPageTray = 259 .OtherPagesTray = 260
Many thanks
Duplicate post, thread closed.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks