Reply
 
Thread Tools Display Modes
  #1   Report Post  
Dlimey
 
Posts: n/a
Default Print mail merge without Print Dialog box

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?
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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?



  #3   Report Post  
Dlimey
 
Posts: n/a
Default

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?




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible to mail merge and print on angle? Kevin Mailmerge 1 August 17th 05 02:04 PM
How do I print mailing labels with mail merge? DanaTunstall Mailmerge 5 February 13th 05 10:09 PM
When attempting a mail merge I get "dialog or database engine fai. Tomdlaw Microsoft Word Help 1 December 22nd 04 12:17 AM
How do i print the envelopes from a mail merge Sandra Mailmerge 1 December 14th 04 02:11 AM
Mail merge print query lucie breadmore New Users 2 December 1st 04 03:30 PM


All times are GMT +1. The time now is 07:47 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"