S
sjSQW
I have a multipage report which repeats for each organisation using a 'group
on' setting. Now I want to export the report to Word in such a way that a new
document is created for each organisation - rather than a single document
with the reports for all organisations, which is the default.
The way I imagine that this can be done is to write a macro that selects
each organisation in turn in the underlying query (or table), and for each
organisation it then exports the report, using the organisation name as the
document file name.
The trouble is, I don't know how to write the code to do this. Can anyone
help?
on' setting. Now I want to export the report to Word in such a way that a new
document is created for each organisation - rather than a single document
with the reports for all organisations, which is the default.
The way I imagine that this can be done is to write a macro that selects
each organisation in turn in the underlying query (or table), and for each
organisation it then exports the report, using the organisation name as the
document file name.
The trouble is, I don't know how to write the code to do this. Can anyone
help?