Word MailMerge Datasource changed

[leslie746]

I need quick programatic solution to the following problem.

I have created a large number of Word documents whereby the recipients contact details are taken from Contacts.mdb located at specific location.

Now, the database has been relocated to a different location and all old documents cannot find their way to the changed location of datasource.

Is there any way to change the datasource location e.g. "C:\contacts\contacts.mdb" for all files in a given directory, so the link with the database can be re-established? What would be the workaround?

An immediate help would be most appreciated.

 

[SkipVought]

leslie746,

Please post VBA Code questions in Forum707.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]