Mail merge cannot locate the data source!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Leong - 19 Oct 2003 04:18 GMT

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!

Reply to this Message

Doug Robbins - Word MVP - 19 Oct 2003 08:21 GMT

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

> I create more than 500 documents (mail merge document) and
> link it to a database in one of our office's server. After
[quoted text clipped - 3 lines]
> location for each mail merge documents. Any solutions?
> Please assist, thank you!

Reply to this Message