sending query results to table in MS Word document 1

[bab]

I'm having trouble sending a set of query results to MS Word. I open Word and add a document, send text ok, now I want to send the results of a query and can't get that to work.

I tried and failed to get the syntax correct for the insertdatabase method. I've tried things like:

With wDoc
.Content.InsertAfter ("Hi&quot 'this works
.Content.InsertDatabase(wdTableFormatSimple2, 191, False, "Query CompanyResults&quot 'this fails
.SaveAs Filename:="c:\test.doc"
end with

I'm sure my syntax is completely off, but I can't seem to find documentation on how to fix it! Many thanks for any help! X-)

 

[Scoty]

Bab,
I had a situation were I had to send a query result as a report everyday via email to several people. What I did was to pull the query through a report and the save the report(

DoCmd.OutputTo acOutputReport, "myreport", acFormatRTF, "myreport.rtf", False

. For what it's worth this is something to try.
Scoty :