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 each
document I am merging (I merge 5 different documents in the process). The VBA
code for the merge is .Destination = wdSendToPrinter and I cannot find a
switch to bypass the dialog box. Just in Word a ActiveDocument.PrintOut
command works but I can't find anything for MailMerge. Any ideas?

Try integrating the code he
http://vbaexpress.com/kb/getarticle.php?kb_id=122
Perhaps you just need the .Execute?
************
Anne Troy
www.OfficeArticles.com

"Dlimey" wrote in message
...
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
each
document I am merging (I merge 5 different documents in the process). The
VBA
code for the merge is .Destination = wdSendToPrinter and I cannot find a
switch to bypass the dialog box. Just in Word a ActiveDocument.PrintOut
command works but I can't find anything for MailMerge. Any ideas?

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?

"Anne Troy" wrote:

Try integrating the code he
http://vbaexpress.com/kb/getarticle.php?kb_id=122
Perhaps you just need the .Execute?
************
Anne Troy
www.OfficeArticles.com

"Dlimey" wrote in message
...
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
each
document I am merging (I merge 5 different documents in the process). The
VBA
code for the merge is .Destination = wdSendToPrinter and I cannot find a
switch to bypass the dialog box. Just in Word a ActiveDocument.PrintOut
command works but I can't find anything for MailMerge. Any ideas?