Try integrating the code here:
http://vbaexpress.com/kb/getarticle.php?kb_id=122
Perhaps you just need the .Execute?
************
Anne Troy
www.OfficeArticles.com
>I have automated a mail merge to both print a merge and send email (Word
> 2000) but for the print process it will display a Print Dialog box for
[quoted text clipped - 4 lines]
> switch to bypass the dialog box. Just in Word a ActiveDocument.PrintOut
> command works but I can't find anything for MailMerge. Any ideas?
Dlimey - 22 Sep 2005 18:38 GMT
Actually I was looking for a printer output (the reference code goes to New
Document) but I changed the destination and still have the same problem. I
was using a more clumsy version of MailMerge (specifying all the options
individually) and this is a cleaner way - thus useful info - but the problem
remains. Interestingly the code does NOT open the Printer dialogue box on my
computer at home. Is it possible the problem is that the work system is a
network printer and is set up differently?
To clarify the problem, it is as though you were to do a File, Print process
vs. click the Printer icon on the toolbar - thus getting the Print dialogue
box.
Any other ideas?
> Try integrating the code here:
> http://vbaexpress.com/kb/getarticle.php?kb_id=122
[quoted text clipped - 11 lines]
> > switch to bypass the dialog box. Just in Word a ActiveDocument.PrintOut
> > command works but I can't find anything for MailMerge. Any ideas?