Creating Word Documents From An Access Query

[FGlick]

I need to find a way to automatically create several Word docs from 1 access query.
NOT A MAIL MERGE!
Example:
I have a query which has 40 records in it according to my criterea.
Let's say that it is employees.
Of those 40 employees, they are divided by 3 supervisors.
I need to automatically create a word doc, one for each supervisor, that
lists all of there respective employees.
Is there a way to do this???
Thank you!

 

[PHV]

Why not a catalog mail merge ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[FGlick]

How do I do a Catalog Mail Merge?
I've never heard of it.

 

[FGlick]

PHV
I found how to do it but it's no different than copying the entire table and pasting it in a document.
It's actually messier than that.
At least pasting the table you get a cell for every field.
It only gives me one document with all employees and supervisors, not a doc for each supervisor.

 

[PHV]

Another option is to create a report grouped by supervisor and then use the DoCmd.outputTo method to create rtf files.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[FGlick]

PHV
They really need to be in Word Docs.
Will I be able to create a separate rtf file for each supervisor or one rtf with several pages?