qeury append to one file

[matrixindicator]

Dim strDir As String
strDir = "D:\2008\MailReportTemp"

DoCmd.SetWarnings False
DoCmd.OutputTo acOutputQuery, "Query1Total", acFormatRTF, strDir & "\" & "MailBody.doc"
DoCmd.OutputTo acOutputQuery, "Query1Detail", acFormatRTF, strDir & "\" & "MailBody.doc"

I can not append two queries in one document ?
I have few queries that I need to paste it in one document.
In this case he produce two reports.
I thought I could use write to file, but then I lose the format of my query. How can I easily solve this ?

 

[PHV]

Use a report with subreports and export it.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixindicator]

ok, thats a possible solution but found also something like
"Merge multiple Word Documents using VBA".