Export individual pages of a report please?

  • Thread starter Thread starter Peter Lawton
  • Start date Start date
P

Peter Lawton

I use access 2002 to produce royalty statements. The report contains 52
pages each page for a different person. I would like to be able to send each
persons page to them individually. If I expert to html it works well but
there is a first, previous, next, last nav line at the bottom. I can edit
this out in notepad but have to do it to each page individually which kind
of defeats the automation process. Alternatively I can export as an rtf but
I have to save each page separately which again is pretty tedious.

Any way around either of these (using other apps if a better way occurs)

thanks for the help
 
assuming that each person is identified by a unique key field(s) and is a
single record or *group* of records in the report's underlying table or
query, you could write code to open a recordset based on that same table or
query, then loop through each person's unique key value, exporting on each
pass through the loop.

hth
 
Back
Top