MS Word Mail Merger from SQL view 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 word 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? I'm open to idea's...

    As always any help is greatly appreciated,

    David92595

  • Just a thought... what if you used bcp or something to crank the resultset into either csv or Excel, and then used that as a source instead of the DB directly? The part I would worry about was keeping the connection open when you really don't need to. Clearly the downside to that is a data "leak"...

  • yea, my higher ups definably wouldn’t go for that. We house sensitive bank information, so any chance of a data leak is out.

    I did get a response from another site, though the person who gave the suggestion never came back to the thread after I asked a follow up question. So I will pose it to you and see if you can find a way to implement his idea.

    He said I'd be better off breaking the process ino two phases: first, loading on the information my useres need to chose the ID

    SELECT ID, ContactName FROM "SQL Mail Merge";

    Then Second, run the actual mailmerge

    SELECT * FROM "SQL Mail Merge"

    WHERE ID = [variable containing the selected value];

    but I have no idea how I would implement this...

    David92595

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply