Opening only ONE document with all the records when merging multiple records from a DB RRS feed

  • Question

  • Hi,

    I'm merging records from Sql Server into a word 2003 document (*.doc). A CRM program\app sends the records to word through an API (I guess).

    When I preform the merge - I get two results at the same time. One is the desired result and one is not:

    1) One document - with multiple merged records.

    2) Several documents - with one record each.

    Lets say I send 3 records for example. I get totally 4 documents opened. 1 with 3 merged records. 3 with 1 merged record.

    I want to get only the single document opened - but cant track what is the root of  this problem. Would thank for and welcome any help.

    Thank you in advance. Ido.

    Monday, March 12, 2012 12:23 PM


  • By default, Word will produce only 1) One document with multiple merged records.

    It is possible to write VBA code to produce 2) Separate records for each document. Do you run a macro to perform the mail merge?

    Regards, Hans Vogelaar

    Monday, March 12, 2012 4:18 PM