>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
.MailMerge.OpenDataSource(THIS.cStatementMergeDataFile)
.MailMerge.Destination = 0
.MailMerge.Execute()
ENDWITH
oWord.ActiveDocument.PrintOut()
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.