I have a very large list that that I want to email different parts of to
different departments. I'd like to save each department's letters into
a separate file as part of the merge process. The question
is how can I merge the document and have part of the merge saved to a
new file each time the department name changes? Ideally, I would like
the file name to be based on the department name.

I've done work with macros similar to this before, but it's been years
and I'm a bit rusty. Thanks for any advice.