Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    15

    Unanswered: from access to word

    Hi

    I would like to do something like this from Access VBA:

    1. create a new Word document;
    2. insert the result of a query in the document;
    3. insert another query
    ...

    is it possible to do that? could someone give me sono sample code?

    thank you

  2. #2
    Join Date
    Jun 2011
    Location
    Inside your mind
    Posts
    297
    Have a read through:

    Create a Word Document with VBA and VBScript: How to Automate Microsoft Word using Visual Basic | Suite101.com

    And then:

    Word Automation from Access - Part II – Inserting Text Into Word Bookmarks

    Gives you all the examples and info to back it up you'll need.


    You'll have to setup bookmarks in word as well, so that it knows where your imported/exported data needs to go.
    Looking for the perfect beer...

Posting Permissions

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