
Signature
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/
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
[quoted text clipped - 26 lines]
>
>.
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 26 Mar 2004 10:38 GMT
By "different set of information" do you really mean information from
different fields, or information for the same fields from a different
record.
The latter does not require the mergefields to be changed. If I was faced
with the former, I would probably use a query in Access to create a dataset
with field names that matched the mergefield names already in the document.
and use that query as the datasource.

Signature
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
> Hi Peter
>
[quoted text clipped - 52 lines]
>>
>>.
Peter Jamieson - 26 Mar 2004 13:58 GMT
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).

Signature
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/
> Hi Peter
>
[quoted text clipped - 52 lines]
> >
> >.
SandyE - 15 May 2004 21:53 GMT
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
[quoted text clipped - 79 lines]
>
>.