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 / December 2004

Tip: Looking for answers? Try searching our database.

Sending Merged Documents to Printer Individually

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
user@domain.invalid - 17 Dec 2004 16:11 GMT
I need to print a high volume (1000) of high quality 4-page brochures
that need to be stapled. After being merged, the printer can not handle
the extremely large size of file.  The printer/copier support indicated
I need to insert a macro, code or VBA macro that will send the merged
documents to the printer individually.  The alternative is printing each
one manually (ugh!)

Does anyone know of a code or macro to use for this?  Any suggestions?

Crys
Doug Robbins - Word MVP - 19 Dec 2004 10:50 GMT
Use the following:

' Throw away Macro created by Doug Robbins
'
Dim i As Long
For i = 1 To ActiveDocument.Sections.Count
   ActiveDocument.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I need to print a high volume (1000) of high quality 4-page brochures
> that need to be stapled. After being merged, the printer can not handle
[quoted text clipped - 6 lines]
>
> Crys
 
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.