hello,

i need to setup a macro (in excel 2007) 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:

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
which seems to work fine for 1 tray, but i think i need to amend it somehow with the following:

.FirstPageTray = 259
    .OtherPagesTray = 260
can anyone show me how to successfully combine the two?!

Many thanks