Consulting

Results 1 to 2 of 2

Thread: Transfer field information form access query to word using VBA

  1. #1

    Transfer field information form access query to word using VBA

    I have a database that I created for a company. It contains employee information as well as projects that he/she has worked on, and general information regarding the projects. What I want to be able to do is to transfer information from a query containing information about the employee and the projects they have worked on and populate them into word. I've heard this can be done through word merge but haven't found any great examples. My latest strategy was to dynamically create bookmarks based on the number of records in a query and then populate those bookmarks using a recordset, but I haven't been able to create multiple bookmarks.

    Any help or advice is welcome, I don't claim to be an expert!

    Thanks!

  2. #2
    VBAX Master stanl's Avatar
    Joined
    Jan 2005
    Posts
    1,141
    Location
    Not really sure of what the bookmarks look like, but you might consider using your queries to build a multi-page access report or form then export that to Word. Just .02

Tags for this Thread

Posting Permissions

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