Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Save Parts of Large Mailmerge as Separate Files
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge groups in large list to separate files | Microsoft Word Help | |||
How do I save MSWord files in WordPerfect format? | Microsoft Word Help | |||
Separate default location for picture files? | Microsoft Word Help | |||
Save As...*.txt files | Microsoft Word Help | |||
Word 2003 files twice as large as Word 2000 files | Microsoft Word Help |