Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    4

    Unanswered: Access 2003 Integration with MS Word

    Hi,

    I'm currently writing a Contracts application in which the contract data, schedules, Statements of Work etc are captured in Access 2003.

    However, in order to produce the contracts I need to export the variable data into standard Word templates containing our default clauses. (I need Word docs as they will be sent for review/revisions by customers/suppliers and I need to maintain change control via track changes.)

    My problem is that I have tried to use a Mail Merge but this appears to create only a document with a relationship to a single record. I do not seem to be able to create in a single Word template a 1 to many relationship e.g. the main contract can have 1 or many Schedules associated with it in ONE merged document. I can only produce many merged documents with the same contract information with a single schedule - which means that I have to copy and paste the additional schedules in one document to form the complete contract.

    Is this possible? Can anyone please suggest how I can do this via Work merge or any other way?

    thanks for the help

    Paul

  2. #2
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404
    I think you're going to be unlucky in this.

    The only thing I can suggest to look at is a temporary table to hold the 1 t0 many info. But remember that the structure of that table has to be reflected in the Word Document (fields etc.).

    In my last post one of colleagues did something like you suggest, but it involve putting a lot of VB code into Word as well as Access (soory no idea what it was).

    Good luck.

  3. #3
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    This looks like the solution for you

    Advanced Word 2003 Mail Merge: Combining Records

    http://cornell.veplan.net/article.aspx?&a=3815

    I hope this helps
    Dale Houston, TX

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •