Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mailmerge from word to Access (word 2002 sp3)

    I know you can do a mailmerge from Access to Word, but can you do a mailmerge from Word to Access. I have a form in Word that my internal customers fills out. I need to get the information from that form into an Access DB table. How would this be best accomplished.

    thanks

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: mailmerge from word to Access (word 2002 sp3)

    You can use VBA in an Access module to read a Word form -- Word must be installed on the same machine. Or you could use VBA in a Word template to insert/update data in your MDB file -- ActiveX Data Objects (ADO) libraries need to be installed on the same machine. Since you have multiple documents, it probably is best to work from Access.

    Now, to read a Word document you of course need to know its structure and how to access the data. Is it a Word form with FormFields, or is it more free-form? Actually, another possibility might be to save the form data out of the Word document as a CSV file. I've seen that option somewhere, but never tried it myself. Then your Access procedure could read in the data from that file.

  3. #3
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mailmerge from word to Access (word 2002 sp3)

    Thanks Jefferson,

    The form has FormFields. I will try saving this as a CSV file and see what happens. If this doesn't work, can you lead me to some documentation on how to read a Word Form through Access?

    warm regards,

  4. #4
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: mailmerge from word to Access (word 2002 sp3)

    This website provides a wealth of sample code to help in transferring info between the various office packages. Adapting something from here will get you going.
    Helen Feddema's Code Samples
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

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