Server Change Affecting Mail Merge Macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Victor Lazlo - 03 May 2005 01:06 GMT

We have relocated all files/directories/documents from one server loction to
another location on the same server and as a consequence all documents that
merged to a source are now displaying error messages since the source server
has changed. Is there a fix (such as a global fix) to preclude the need to
link each document to the new server location name?

Reply to this Message

Cindy M -WordMVP- - 20 May 2005 14:09 GMT

Hi =?Utf-8?B?VmljdG9yIExhemxv?=,

> We have relocated all files/directories/documents from one server loction to
> another location on the same server and as a consequence all documents that
> merged to a source are now displaying error messages since the source server
> has changed. Is there a fix (such as a global fix) to preclude the need to
> link each document to the new server location name?

Not really. Depending on whether this is Word 2003 you could possibly use VBA
code, together with the new security option, to open the documents
programmatically, dropping the data source link. But then they'd have to be
linked back to the data source, somehow. And if all the documents don't link to
the same data source, this probably wouldn't save a lot of time...

Fastest would be to reinstate a server with the same name and path structure,
use VBA code to open the documents in turn and connect them to the new server
path (since the connection information would still be present, unlike the first
proposal).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message