Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    25

    Unanswered: Integrating Access and Word

    I want to know if the following is possible and if there is any potential bugs that I should be aware of:

    I would like to build a table and form to store MS Word documents that my user creates. This is easily accomplished by inserting an object into a bound OLE field on the form.

    The thing is, I would like the file to be a mail merge document connected to a query from the same database. If possible, I would like to be able to merge the letters to the printer from within access. The main trouble that I think I'm having is that I lose the Word Mail Merge controls from the menu when I insert the document into my form.

    The end result is that I want my users to be able to create merge style letters, but I would like to keep the link between access and word as seemless as possible.

    Any suggestions?

    Jeff Perry

  2. #2
    Join Date
    Sep 2002
    Location
    Land of OZ
    Posts
    173

    Re: Integrating Access and Word

    Originally posted by perryjm
    I want to know if the following is possible and if there is any potential bugs that I should be aware of:

    I would like to build a table and form to store MS Word documents that my user creates. This is easily accomplished by inserting an object into a bound OLE field on the form.

    The thing is, I would like the file to be a mail merge document connected to a query from the same database. If possible, I would like to be able to merge the letters to the printer from within access. The main trouble that I think I'm having is that I lose the Word Mail Merge controls from the menu when I insert the document into my form.

    The end result is that I want my users to be able to create merge style letters, but I would like to keep the link between access and word as seemless as possible.

    Any suggestions?






    Do you need to store the actual document in the database, why not store the path to the document in the database and this will retain the mail merge features of the document.
    Jeff Perry
    Mona
    ________________________________
    Life is too short to be sane or sensible. Weird people rule and normal people suck

Posting Permissions

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