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.

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
Word MVP web site http://word.mvps.org




John wrote:
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.

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.




"John" wrote in message
...
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.