If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find and Replace Merge Codes
Hi Dave... I work in a law office too in WPG. I know
exactly what you meant about changing the protocols. What we really need is a tech who understands the requirements of the lawyer (BTW I'm a legal assistant, 25 yrs, but completely self taught in computers). I tried to write the loop-macro in VBA, but unfortunately the tech who was teaching me left and its only half-done..I have an extensive Access database for my foreclosure/litigation practice, so I'm going to try these suggestions. SandyE. -----Original Message----- First, I was going to say the same thing as Doug re. using Access queries (or similar) to "hide" underlying column name changes. The way I see it is that if you have a serious data management problem it is probably better to try to solve that problem using data management tools than by creating what I suspect could be large numbers of variant Word documents which might be even harder to manage longer term. As for the VBA side, I would suggest that you have a look at the bottom section of http://word.mvps.org/Tutorials/index.htm for starters, then perhaps look at the Macros/VBA tab at http://word.mvps.org/FAQs/index.htm There is an example of how to process a complete folder of .doc files at http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm but I suspect I would probably /not/ use find/replace but use a loop to look through all the merge type fields in each document and modify the fields that way. There are sample code snippets in this group (which you can search using the Groups tab at Google). -- Peter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ "Dave G" wrote in message ... Hi Peter A lot of information is merged into a variety of documents via our Case Management system. Most of it is to do with House Sales and Purchases. Things then change in the protocols and a wide variety of documents need to change to reflect this, often by having to merge a different set of information which is already in the Case Management system - hence the need for globally changing merge fields. My knowledge of VBA is pretty limited I am afraid. If you could give me some clues I would really appreciate that. Dave -----Original Message----- In order to globally change merge codes in all documents you really have to write VBA to search for the fields you want and replace them. In principle, if all you are doing is changing field names in the data source, in Word 2002/2003 you ought to be able to introduce new field name mappings via VBA, but in practice this is impossible. From the user interface, your options are extremely limited. You can turn on view field codes and search for the field code brace + some text, (use e.g. ^d^wREF xyz ) but the only way you can insert a field code as the replacement is to copy the field code you want into the clipboard prior to your search and use ^c in the Replace box. But what kind of things are you changing all the time? -- Peter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ "Dave G" wrote in message ... Hi If there a way of finding and replacing merge codes? We use merging extensively in the law office where I work, particularly with our case management system, and are desperately looking for a way of globally changing merge codes without having to trawl through hundreds of dicuments everytime something changes. Any thoughts gratefully reveived. Dave . . |
Thread Tools | |
Display Modes | |
|
|