How to update mailmergefields?

I am creating a VBA that will update mailmerge documents. One set of data to
many files. One of the MVPs suggested a good start. I am not finding a way
to use the MailMergeField to be able to update the field itself. I have
looked through the methods but I am a bit rusty on Oject Oriented code. I
would appreciate some additonal insight.

Thank you
--
FL Consultant

Jean-Guy
Fri Jul 22 09:01:18 CDT 2005

FL Consultant was telling us:
FL Consultant nous racontait que :

> I am creating a VBA that will update mailmerge documents. One set of
> data to many files. One of the MVPs suggested a good start. I am
> not finding a way to use the MailMergeField to be able to update the
> field itself. I have looked through the methods but I am a bit rusty
> on Oject Oriented code. I would appreciate some additonal insight.

Mailmerge fields cannot be updated as such. You insert mailmerge fields in a
document, then you execute a merge. Once the merge is finished, the
resulting document does not contain fields anymore.

What is it you are trying to do exactly? Also, it would help us help you if
you posted the relevant code so that we can see what you have and give you
useful pointers.
As is, your post is very vague...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

FLConsultant
Sat Jul 23 05:15:01 CDT 2005

Thank you for responding. What I am attempting to do is to take one set of
data and update many documents. The data consist of name, address, phone,
and other information. The document are different contracts that all need
the same data. There are in fact a total of 250 contracts.

One MVP suggested using Find & ReplaceAll (BatchReplaceAll()) from the MVP
website. That was good suggested except it will only work with one piece of
data.
I do not have any code thou I am developing some test stuff as I experiment.

It seems to me that there must be a way to do what I want to do. For
example, I am able to locate the MailMergeField. Is there a way to change
the field, and than I could print the new document or save it as new
document. By printing or saving the changed document, I would not change the
original document that contains the MailMergeFields and the document could be
used again for MailMerging.

Is there a method that will allow me to change the MailMergeField? Or is
there another way to do what I am attempting to do?

I have since learned that the initial need for me to create this
funtionality is no longer needed but as a programmer I still feel challenaged
and would like to see if I can make this work.

I hope this response gives you the information you need and I thank you for
taking the time to respond and any suggestions you might have.
Thanks

--
FL Consultant


"Jean-Guy Marcil" wrote:

> FL Consultant was telling us:
> FL Consultant nous racontait que :
>
> > I am creating a VBA that will update mailmerge documents. One set of
> > data to many files. One of the MVPs suggested a good start. I am
> > not finding a way to use the MailMergeField to be able to update the
> > field itself. I have looked through the methods but I am a bit rusty
> > on Oject Oriented code. I would appreciate some additonal insight.
>
> Mailmerge fields cannot be updated as such. You insert mailmerge fields in a
> document, then you execute a merge. Once the merge is finished, the
> resulting document does not contain fields anymore.
>
> What is it you are trying to do exactly? Also, it would help us help you if
> you posted the relevant code so that we can see what you have and give you
> useful pointers.
> As is, your post is very vague...
>
> --
> Salut!
> _______________________________________
> Jean-Guy Marcil - Word MVP
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site: http://www.word.mvps.org
>
>
>
>

Jean-Guy
Sat Jul 23 13:14:11 CDT 2005

FL Consultant was telling us:
FL Consultant nous racontait que :

> Thank you for responding. What I am attempting to do is to take one
> set of data and update many documents. The data consist of name,
> address, phone, and other information. The document are different
> contracts that all need the same data. There are in fact a total of
> 250 contracts.
>
> One MVP suggested using Find & ReplaceAll (BatchReplaceAll()) from
> the MVP website. That was good suggested except it will only work
> with one piece of data.

You can do the "Replace" routine many times. The best is to create a
Function that does the Find/Replace and to call this function as often as
you need passing it string variables to specify the find text and the
replace text.

> I do not have any code thou I am developing some test stuff as I
> experiment.
>
> It seems to me that there must be a way to do what I want to do. For
> example, I am able to locate the MailMergeField. Is there a way to
> change the field, and than I could print the new document or save it
> as new document. By printing or saving the changed document, I would
> not change the original document that contains the MailMergeFields
> and the document could be used again for MailMerging.
>
> Is there a method that will allow me to change the MailMergeField?
> Or is there another way to do what I am attempting to do?

If all the documents are merge source documents, i.e. they contain mailmerge
fields prior to a merge, look at the Code property of the mailmerge field
object.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

FLConsultant
Sun Jul 24 06:04:01 CDT 2005

Thank you for your assistance.
--
FL Consultant


"Jean-Guy Marcil" wrote:

> FL Consultant was telling us:
> FL Consultant nous racontait que :
>
> > Thank you for responding. What I am attempting to do is to take one
> > set of data and update many documents. The data consist of name,
> > address, phone, and other information. The document are different
> > contracts that all need the same data. There are in fact a total of
> > 250 contracts.
> >
> > One MVP suggested using Find & ReplaceAll (BatchReplaceAll()) from
> > the MVP website. That was good suggested except it will only work
> > with one piece of data.
>
> You can do the "Replace" routine many times. The best is to create a
> Function that does the Find/Replace and to call this function as often as
> you need passing it string variables to specify the find text and the
> replace text.
>
> > I do not have any code thou I am developing some test stuff as I
> > experiment.
> >
> > It seems to me that there must be a way to do what I want to do. For
> > example, I am able to locate the MailMergeField. Is there a way to
> > change the field, and than I could print the new document or save it
> > as new document. By printing or saving the changed document, I would
> > not change the original document that contains the MailMergeFields
> > and the document could be used again for MailMerging.
> >
> > Is there a method that will allow me to change the MailMergeField?
> > Or is there another way to do what I am attempting to do?
>
> If all the documents are merge source documents, i.e. they contain mailmerge
> fields prior to a merge, look at the Code property of the mailmerge field
> object.
>
> --
> Salut!
> _______________________________________
> Jean-Guy Marcil - Word MVP
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site: http://www.word.mvps.org
>
>
>
>