>I have a piece of code that produces financial statements via a Word mailmerge. It works fine except that it brings up a printer dialog box before printing. As we'd like to run this as part of an overnight batch, this is rather annoying! Any suggestions to remove the dialog would be welcomed.
>
>WITH .Documents[1]
> .PageSetup.FirstPageTray = 2 && each statement will only ever be one page long
> .MailMerge.OpenDataSource(THIS.cStatementMergeDataFile)
> .MailMerge.Destination = 1 && Printer
> .MailMerge.Execute()
>ENDWITH
>
>Thanks in advance.
>
>***
>Win2K Professional, Word 97 SR2, Fox 8 SP1

Try:

WITH .Documents[1]
     .PageSetup.FirstPageTray = 2  && each statement will only ever be one page long
     .MailMerge.OpenDataSource(THIS.cStatementMergeDataFile)
     .MailMerge.Destination = 0	&& File
     .MailMerge.Execute()
ENDWITH
oWord.ActiveDocument.PrintOut()