Print from different paper trays

[Garry]

1. I need to print a personalised letter from tray 1 on letterheaded paper.
2. Next I want to print a personalised subreport from tray 2 on plain
paper.

I need to print this two part mailshot in one go and post out 10,000
letters.
Any thoughts, many thanks Garry

 

[Rod]

I don't know how to do this using Access but I do know
that you could do this with Word. Use a mail merge and
then setup the printing from within Word. You'll only have
to build this once.

 

[Garry]

Thanks for the reply

I have managed to setup from Word using the print driver software.
It works for the very first record but then prints all remaining pages from
tray 2. It does not revert back too tray1, tray2 etc.