Mark:
There are multiple ways to do this, however none of them are particularly
"elegant" solutions.
The problem is that Access can not change the tray assignment of a report
while it is running, flipping between trays. So you have a few options:
1.) Create two reports, one which represents the first page and one which
represents the second page and send them in succession to the printer so
that the whole thing prints in one batch with two print jobs.
2.) Search the MS knowledge base for an article on how to print the odd or
even pages of a report, and combine that will code that after printing the
odd pages (i.e. the pages that go to letter head), you open the report in
design mode via code, and switch the tray assignment, save the report and
pirnt the even pages, then reverse the process to reset the tray for the
next time you start the process so that it prints to the tray with
letterhead. Again, two print jobs with a bunch of code in the middle to
switch tray assignments for your one report.
3.) Use something like our On the Fly Printing code and classes to switch
the tray assignments for you via code, but to do this, you'd end up having
to filter the report, one recipient at a time, printing first to the
letterhead tray and then to the plain paper tray, so you'd have 50 or so
print jobs. You'll find this on our web.
