How can I perform a Word mail merge to separate files

[jjeffh]

My agency has about 40 departments and each must submit an annual report. The
report form is 3 pages long and contains individual statistical data
collected over the course of the year from each department. It also provides
areas for comments and additional information from the department directors.
The report form is a Word Main Document, for merging. The Data Source is an
Excel spreadsheet.

When the statistical data has been merged into the report form, I have to
save each department's individualized report form as a separate document so I
can give it to the director as an electronic form they must complete on the
computer.
What is the easiest way for me to accomplish that? I'm currently using
Office 2000. (We'll be upgrading to Office 2003 this year, but not in time
for this project).

Thanks,
- Jeff

 

[jjeffh]

Browsing after posting this, I found several other threads addressing this
issue. I will try those methods and see if it works for my situation.

Thanks,
- Jeff