Word MailMerge Datasource Relocated

[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]

Hi,

As a starting point, out of HELP...

    With ThisDocument.MailMerge
        .OpenDataSource _
            Name:="C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb", _
            LinkToSource:=True, _
            AddToRecentFiles:=False, _
            Connection:="TABLE Customers"
    End With

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}