• I presume you are referring to a Microsoft Word mail merge document that is being merged using some VBA code. Unfortunately, doing that from a .ADP project appears to be rather challenging technically, and reported to not be terribly reliable, but isn't something I have personally done. However I do have substantial experience with doing merges from .MDB format Access databases using SQL Server back-ends, and I would suggest that you consider the alternative of Automation to do a single document, using a Word template and bookmarks in Word to populate the data from the form. The link Automation 101 can be used as a starting point to explore Automation. Many of the references are rather dated, but the concepts are still valid.

    The other option is to use a report within your ADP project, but the formatting options available on reports aren't as powerful as you have with Word. If you are trying to create a document that is more like a letter, then Word is the better choice.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!