I have a very large list that includes department names that I want to
merge each department's letters into a separate file. Thus, each
merged department document could be emailed separately. The question
is how can I merge the document and have 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.

Perhaps if you could translate your question into English and re-post...?



"BlueWomabt" wrote in message
oups.com...
I have a very large list that includes department names that I want to
merge each department's letters into a separate file. Thus, each
merged department document could be emailed separately. The question
is how can I merge the document and have 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.

Maybe my crystal ball is a bit clearer than Jezebel's this morning?

You cannot split a merge document into separate files on the fly. You can
merge to a new document and split that into individual letters
http://www.gmayor.com/individual_merge_letters.htm, or by inserting a marker
in the merge when the split point changes, you could adapt the macro to use
that point instead of the section break to split the document.

Or more simply, you could run separate merges for each group of records.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



BlueWomabt wrote:
I have a very large list that includes department names that I want to
merge each department's letters into a separate file. Thus, each
merged department document could be emailed separately. The question
is how can I merge the document and have 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.