Link to home
Start Free TrialLog in
Avatar of mlcktmguy
mlcktmguyFlag for United States of America

asked on

Reports To Different Trays

I have developed an application for a client that has the one option to print a cover letter and account statement for a given client.  These will be done one client at a time.  Both of the outputs are on 8.5 x 11.  The account statement prints on a pre-printed form.

The would like the client letter to be sent to tray 1 and the statement to tray 2.  How can this be done generically on a report?  The only options I see on page set up are
Automatic,  Manual Paper Feed and Cassete.  I guess setting the statement to Manual would at least pause so they could change the paper but a smoother process is obviously preferable.
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
<The account statement prints on a pre-printed form.
The would like the client letter to be sent to tray 1 and the statement to tray 2. >
So the "Account Statement" and the "Client Letter' are two separate "Reports"?
If so, you may be able to do this by setting the default printer in the Report's Page Setup and select the needed tray in the Properties...

Another option would be to recreate the "Account Statement" with an Access report. (by scanning the original and inserting it as a graphic on an Access Report.)
Then you could even connect the two reports (use one as the Report or Page Header) and print them out at the same time on the same printer.
Avatar of mlcktmguy

ASKER

Sorry for the delay, I haven't had a chance to evaluate/try any of the suggestions.
Okay - The solution I posted is tried and true, so I'm confident that it will work for you.

That said, if you have any issues with it, I am still subscribed to the question and you can either post here with any follow up problems or use the Request Attention button to have the question reopened.