Print word document and possible merge

[GShen]

Hi,
1)Is there any way of printing a word document from ACCESS?
I looked up a number of DOCMD actions to no avail. Do I need to use a Shell or Cmd Object ?
2)Also it is possible to merge them to 1 document ? Ex. I have a folder of 1 thru x documents by a number of users. I want to print them in 1 document so I can staple them together instead of looping thru and printing each one seperately.
3)Lastly, I also have 2 access reports which I would like to merge with them as well.

#1 above is the minimum I need to get working. If I can't merge (#2 and #3), then I will print seperately.

Thanks.

Remember when... everything worked and there was a reason for it?

 

[GShen]

found it.
for anyone needing this
Function PrintDoc(RptToPrint As String)
Dim WordObj As Object
Set WordObj = CreateObject("Word.Application")
WordObj.Documents.Open RptToPrint
WordObj.ActiveDocument.pagesetup.PaperSize = 2 'Set to letter size
WordObj.ActiveDocument.Save
WordObj.PrintOut Background:=False
WordObj.Quit
Set WordObj = Nothing
End Function

Remember when... everything worked and there was a reason for it?