Merge to Printer without Print dialog box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msr - 24 Nov 2003 15:33 GMT

I have a VB6 application that creates an invisible
instance of Word and does a mail merge to printer. Is it
possible to not display the print dialog box with the
cancel button that appears when the merge is processing?
Thanks.

Reply to this Message

Peter Jamieson - 25 Nov 2003 13:31 GMT

http://www.mvps.org/word/FAQs/MailMerge/MergeStraightToPrintrWVBA.htm

describes the only method I know.

--
Peter Jamieson - Word MVP

> I have a VB6 application that creates an invisible
> instance of Word and does a mail merge to printer. Is it
> possible to not display the print dialog box with the
> cancel button that appears when the merge is processing?
> Thanks.

Reply to this Message

- 26 Nov 2003 00:47 GMT

Thanks. Does the merge take longer when merging to a
document vs the printer? I have been using the merge to
document and printing, but merges with a lot of data were
taking so long so I thought I would try to the printer to
see if it would perform better.

msr

>-----Original Message-----
>http://www.mvps.org/word/FAQs/MailMerge/MergeStraightToPrintrWVBA.htm
[quoted text clipped - 11 lines]
>
>.

Reply to this Message

Peter Jamieson - 26 Nov 2003 06:33 GMT

Yes, if you have a lot of records the output document will be large and you
will probably find that after a few hundred records things start slowing
down. I suppose you can always consider doing multiple merges, e.g. records
1-100, 101-200 etc., which may or may not be straightforward depending on
what your merge is doing, but then your merge process is beginning to get
more complex. Also, some constructs in Word mailmerge main documents (such
as formatted bullets) can cause the merge to be extremely slow.

--
Peter Jamieson - Word MVP

> Thanks. Does the merge take longer when merging to a
> document vs the printer? I have been using the merge to
[quoted text clipped - 23 lines]
> >
> >.

Reply to this Message