For anyone watching, I solved it! there is always a way.
Make a word document, insert some bookmarks and hey presto in VBA you can automate the process of:-
1. Open a QUERY (to filter your data)
2. Select All records
3. Copy
4. Close the Query
5. Switch to word
6. Locate bookmark
7. Paste the clipboard
8. Format the table
By having multiple bookmarks in msword templates etc you can create custom reports with multiple tables of data and text.
If anyone would like the sourcecode or a sample let me know (should you ever have need of something like this).
--> works a treat for planned maintenance notificatins / inspection reports etc.
Joe
