Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2007

Tip: Looking for answers? Try searching our database.

wdSendToPrinter - Multiple copies

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ksg - 20 Feb 2007 19:59 GMT
I have an automated mail merge setup to require no user interaction.  I have
a file with all the merge information including the number of copies.  
Everything waorks fina as long as I use the default printer and only need one
copy.

The problem is I need to select the printer and the number of copies without
any user interaction prior to printing.  How do I send that information to
the printer using VB and the wdSendToPrinter command?

Any help would be appreciated.
Doug Robbins - Word MVP - 20 Feb 2007 20:17 GMT
I believe that you will need to execute the merge to a document to be able
to print more than one copy of it.

See the article "How to do a mail merge to the printer using VBA, without
displaying the Print dialog" at:

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

For selecting the printer, see the article "Changing the selected (current)
printer in Word without changing the system default printer" at:

http://www.word.mvps.org/FAQs/MacrosVBA/ChangeCurPrinter.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have an automated mail merge setup to require no user interaction.  I
>have
[quoted text clipped - 9 lines]
>
> Any help would be appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.