Mail merge cannot locate the data source!

[Michael Leong]

I create more than 500 documents (mail merge document) and
link it to a database in one of our office's server. After
I take back the documents and the database from the server
and put it in my laptop. The mail merge document cannot
locate the data source. I must edit the data source
location for each mail merge documents. Any solutions?
Please assist, thank you!

 

[Doug Robbins - Word MVP]

Hi Michael,

You can use the .DataSource property of the Mailmerge object to get the name
of the existing datasource and then use the .OpenDataSource method to attach
the datasource from it's new location.

This could be done with a batch process, using a modification of the
procedure in the article "How to Find & ReplaceAll on a Batch of Documents
in the Same Folder" at:

http://www.mvps.org/word/FAQs/MacrosVBA/BatchFR.htm

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