Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merge groups in large list to separate files
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separate default location for picture files? | Microsoft Word Help | |||
Recent files list not available in Word options dialog. | Microsoft Word Help | |||
print list of files in a folder | Microsoft Word Help | |||
can data fields be added to an exisiting mail merge address list | Microsoft Word Help | |||
Word 2003 files twice as large as Word 2000 files | Microsoft Word Help |