pagebreak in queries

[Lupe]

Hi,
I have created a query of personnel info which I am exporting to Excell via
a macro with OutputTo.
For printouts In Excell we are going to need page breaks per departments. Is
it possible to do a ForceNewPage in a query in Access. I have gone thru many
of the postings but they all addressed reports. In Excell I've found a way
but when I run the macro from Access to update the data it overwrites the
Excell file.
I need to force a new page each time the department code changes.
Regards, Lupe

 

[Lupe]

Hi Phil,
I can do it in Excell but the only thing is that whenever I run the macro
from Access it overwrites the data and the file. That's why I want to look
into the possibility to do it directly in Access first and then export it to
Excell with the page breaks already there.
Lupe