A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Find and Replace Merge Codes



 
 
Thread Tools Display Modes
  #1  
Old May 15th, 2004, 09:53 PM
SandyE
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.