#1
|
|||
|
|||
Can I use the filter function to separate letters into separate files?
Good morning, My name is Dan. I am new to this forum. I have a large document in which about 2,000 names are contained in 25 buildings. Is there a way I can use the filter function (or any function, really) to split the document and save by building (25 separate files)? I've been filtering each building individually and saving unique files, so I have to filter and save 25 times. Have a good day! Dan |
#2
|
||||
|
||||
Hi Dan,
You can use Word's Catalogue/Directory Mailmerge facility for the filtering (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://windowssecrets.com/forums/sho...ngs-(2000-2010) or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. Do note that the filtered data will still be in one file, though. If you really need separate files, you can use a macro to split the output file afterwards. Post back if that's what you need.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] Last edited by macropod; 12-14-2011 at 02:24 PM. Reason: Clarification |
#3
|
|||
|
|||
Good afternoon Macropod,
Thank you so much for passing this along! I'm about to start the tutorial. Have a good day, Dan |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to have separate references in each chapter | staphlee | Word | 1 | 11-06-2011 05:54 AM |
Adding identical footers to 187 separate docs | sqzdog | Word | 11 | 10-31-2011 01:46 AM |
Separate Address Book (or Contact folder) | AlanW | Outlook | 3 | 05-24-2011 11:12 AM |
Any easy way to separate a Word document into separate files? | SamHelm | Word | 0 | 08-21-2010 05:29 AM |
Cannot open two separate MS word window | bunny_biceps | Word | 2 | 08-17-2010 01:51 PM |