Issues with Word merge using VB.
Posted on 2016-08-16
We use a construction project management system called Prolog with a SQL back end. When a contract is generated Prolog opens the appropriate document in Word 2013 and uses VB to merge data from SQL into the document.
We have Prolog and Office 2013 installed on a dedicated XenApp 6.5 server running on Windows 2008 R2.
The problem is, for some users you can see the merge taking place, but once the merge is done the document loses all the merged data and you're left with the original, un-merged document. We have already tired different versions of Office, making the user a domain admin, deleting the user's Citrix profile and letting it re-create, and logging on to the Citrix server locally, but nothing has worked thus far.
Any ideas or possible avenues to explore?