View Single Post
 
Old 08-23-2013, 03:42 PM
David92595 David92595 is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jul 2011
Posts: 4
David92595 is on a distinguished road
Default Mail Merge Word Doc over SSL VPN

Hello,

I am trying to mail merge a document over an SSL VPN connection. I can open a Word doc that is on our server, but when I try to mail merge the document, it freezes, or takes about 30 seconds to search 200 records. We have 16,000 records... When I'm in the office it take 2-3 seconds to mail merge.

I am using a data source that connects to a view on our SQL server. I have tried recreating the mail merge with Schema binding so I could create a unique Clustered Index on the base table's primary key, which is also the field we use to search for our records.

This they anything I can do to speed things up?
As always any help is greatly appreciated,
David92595
Reply With Quote