is a mail merge main document. Word cannot find its data source

I've run into this problem more than once.  The exact solution for us hasn't been posted on the net.  Close, but not a fix.

After a night, I found the answer for our version of the issue.

In my case, Terminal Services Users are getting these errors while running a Data Merge in Word 2003.
The document was recieving the merged data from another server on our LAN.

I've also had this problem in Word 2002.  The terminal server is Server 2003 in both cases.

The solution is to add the (name or IP of the) remote data server to the Internet Properties>Security>Trusted Sites>Sites  
list in the format; "file://server" with your server name or IP address replacing server, and no quotes.
(I have included this in the script below, if you'd rather script it instead)


Sometimes the error is preceded by another error saying....
Opening this document will run the following SQL command:
SELECT * FROM H:\HDS\BLAH\BLAHBLAH\BLAH\SOMETHING.DLW
Data from your database will be placed in the document.  Do you want to continue?

That requires a reg fix that I'll post below in script form.  The reason I use a script is that some of these reg entries need to be made while logged in as that user, and I don't know a way to edit the HKCU key of a user who isn't logged in.  Since I have a number of users I wrote the script and set it as their login script.

Set WshShell = Wscript.CreateObject("Wscript.Shell")
WshShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options\SQLSecurityCheck", "00000000", "REG_DWORD"
WshShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options\CalcDataFieldOnOpen", "00000001", "REG_DWORD"
WshShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\EscDomains\Your_Server_Name\*", "00000001", "REG_DWORD"
WshShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\EscDomains\Your_Server_Name\file", "00000002", "REG_DWORD"

Cut and past the above (including quotes) into a .vbs file.

This applies to Word 2003.  If you're using Word XP / 2002, then change the 11.0 to 10.0 .  Also, replace Your_Server_Name in the last 2 keys with the name of your server.  
Since both issues seem to come together, I normally use the entire script.

To setup a login script for terminal services users, view the MS document here....
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q315245

Hope this helps someone

NV