Try again

[Guest]

I posted this question a couple weeks back and got no replies. So I'll try
again.

I have read several posts on how to programatically set the paper bin, but I
haven't been able to find any post that addresses my particular need. I have
a report, which is a letter to clients. When I click the Print Report button,
the same letter prints to each of 80 clients with client specific data
interspersed throughout the letter. I need to be able to specify that the
report prints to the Upper paper tray for the first page of each client's
letter (so we can use letterhead paper) and to the Manual paper tray for any
additional pages (so we can use plain paper). There are some, but few,
letters that are more than one page. I have set the Page number to reset to 1
in the Group Header section and so I was hoping that I could simply put code
in one of the On___ events that would say "If Page > 1, Paperbin = Manual".
Thanks in advance.

 

[John Spencer (MVP)]

I think you would have to print the report once for each client and limit the
report to one client at a time.

You could probably do this using VBA and a loop to step through your records.

Hope this helps get you started.