Hi,

I have a mailmerge document connected to a excel named range. The link
reference is to a library below my 'office standard library'.

When I send the excel source file and the mailmerge word document to
other users, the link/connection doesn't work. I guess it still is
pointing to my own library path and not theirs.

How can I update the refererence path /mailmerge connection so it will
be correct for the user?

I have some code from excel i probably can use in word also (se below
if your are interested) to find the right path, but i'm not used with
VBA in word. Should I create a add-in that do this  on opening event
and when this filename is the right one? Or can you have som vba code
follow the word file? When I try to save VBA in the ThisDocument
module, it will get lost after reopening...

Kind regards
Tskogstrom

-----------------------------------
In a excel application i use this function in vba to identify standard
library(should be able to use it in word(?)):

Function stdDocumentPath()
'Let you know the standard document catalog of the user = myDocPath
'*************************************''

Dim myDocPath As String
On Error GoTo stdDocumentPath_Error
Let myDocPath = Application.DefaultFilePath

'Add a "\" at the end of the path, unless the setting is already
followed by a "\" -
'which it will be if the setting is set to a root folder
If Not Right$(myDocPath, 1) = "\" Then
   myDocPath = myDocPath + "\"
End If

Let stdDocumentPath = myDocPath
Debug.Print "stdDocumentPath: " & stdDocumentPath

On Error GoTo 0
Exit Function

stdDocumentPath_Error:
Debug.Print "Error " & Err.Number & " (" & Err.Description & ") in
procedure ""stdDocumentPath"" of Module UsedCode"
Debug.Print myDocPath
Debug.Print stdDocumentPath
Sheets("Show").Range("a1").Value = "Fel"
On Error GoTo 0
Exit Function

End Function

I call it with:
'Open source file, copy content and paste in this workbook
Workbooks.Open (orgStdPath & FolderName & "\" & SourceDoc)

... where FolderName is the name of the folder "Merge" and SourceDoc
is the name of the Excelfile that is the data source to the word
mailmerge document.