Save Parts of Large Mailmerge as Separate Files

[John]

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.

 

[Graham Mayor]

You appear to have asked this in a number of Word neswgroups at least two of
which have received replies.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Jezebel]

Run separate merges, one for each department, using the department name as
part of the query WHERE clause. Save each into a separate file.

You could automate the whole process if you really need to, but unless you
have a large number of departments or you're going to be doing this
repeatedly, it's probably not worth the trouble.