VB / VBA Printing - Choose Tray from Code?

[Pace]

Hi All,

I was wondering is it possible in code to write a print funtion that would take the initial page from one tray of a printer and everypage their after from another tray?

I dont need the code to do this, I just need an answer as to weather or not this is possible... And if you knew, it would be great if you could tell me if this was possible from VBA... or just .net.

Thanks for you help =)

Pace

 

[mjb3030]

Yes. It is possible in .net anyway. Look at the QueryPageSettings Event. It is called directly before every PrintPage event. The QueryPageSettingsEventArgs gives you the PageSettings property which lets you specify which paper tray to use.

In VBA, you would more than likely have to use an API call.

 

[Pace]

Thanks mjb3030