Merging two reports

L

Leroy

Is it possible to make a macro or something in access 2003 that will export
two reports but append the second report on a new page of the same word
document?
I was able to create a macro in word that would merge two documents, I'm
just curious if doing something similar in access would be possible to make
the job less confusing. Basically I have a macro that already exports the two
word documents, and they have to open one of them and run this macro.

--------------------------Word Macro -------------------------------

Sub Foo()
Application.ScreenUpdating = False
Documents.Add
With Application.FileSearch
'Search in foldername
.LookIn = "C:\test"
.SearchSubFolders = False
Selection.InsertFile FileName:=("Cover.Doc"), _
ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.InsertBreak Type:=wdPageBreak

Selection.InsertFile FileName:=("Blotter.doc"), _
ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.InsertBreak Type:=wdPageBreak

End With
End Sub

-------------------End Macro-----------------------------------

Is this macro possible in Access or is there another way of automating this
process? Any information would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top