So, I’m sending out some scheduling forms to clients. All of the neccessary information is in an access database. Each letter must be customized to that client outlining the description of the particular therapy they are assigned to (25 different types).
I built a form to easily enter the information into the database table - that’s done.
I’ve created queries of each of the 25 different types of therapy - that’s done.
I’ve written the letters in MS Word - that’s done.
Now - the problem. When in Word, when selecting the MERGE function, I only see the access TABLE available to merge the information from, and I need to merge from the QUERIES I created.
Please help me figure out how to get the queries to display in the merge funcion!
If I were doing this I would create the letters using an Access report rather than using a Word mail-merge.
But if you want to use Word, and if Word can’t be made to list Access queries you could change your queries to Make Table Queries*. That way when you run the query a new table will be created which contains the results of the query. Then use that as the source for the Word mail-merge.
Select Make Table Query from the Query menu when viewing the query in design view.
Imassquare - what is the advantage of using the report function rather than word to create the letters (other than to avoid my situation of course <g>)?