Problem with mail merge document being created through VBA RRS feed

  • Question

  • Hi,


    We have a macro in word which reads the data from the PASCAL application and creates the mail merge document.
    Mail merge document is created by using two document Header document and the Main document. The DDE linking methodology is used to create this mail merge document.

    Everything was working fine until when the record size grew. It works fine till the record count is 2200, but when the count exceeds the application gets hangs. We have written the code in the VBA and word being used in Word2007.

    Thinking that this issue is with respect to the memory constraints we tried to split this mail merge document in the multiples of 1000 records per document close each once as and when the count is reached and then at the final stage we have merged this spilt document and created a mail merge document. But still the problem exists can any one give some work around or some snippet to manage the memory from the VBA code.

    Thanks in advance,

    • Edited by Sri-Ram Friday, May 22, 2009 5:24 AM
    Friday, May 22, 2009 5:23 AM


  • Hi,

    Thank you for contacting "Innovate on Office" forum!
    We provide support on advisory issues for MS office 2007 where we address "How-to" questions. The issue submitted by you requires troubleshooting, that’s why this forum is not the right place to post your issue.
    Depending upon your partner level, you have the following three options available to use our services:
    1.     Purchase an incident pack.
    2.     Contact the main-stream support team of Word in Microsoft.
    3.     You can call Customer service representative (CSR) at 1-800-936-5800 X 88987
    - Use one of the incidents available to you.
    - Visit https://partner.microsoft.com/global/supportsecurity/technicalsupport/40014662



    Tuesday, June 2, 2009 5:05 PM