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.

How to mail merge with a folder option?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NedF - 08 Dec 2004 16:59 GMT
We are using Word 2003 with a Minolta CF-5001 color copier. The Fiery model
is an S300 50C-K v1.1.  The copier has tri-fold ability.  The problem we are
having is getting the copier to fold each individual letter in a merge.  
Right now the copier will attempt to tri-fold all pages in the merge document
together.  I'm not sure if this is a Word problem, a Fiery driver problem or
ignorance on my part.  Apart from sending each merged page individually does
any one know how to make Word or the print driver recognize that each letter
within the merge should be handled separately?  We have the problem whether
we merge to a document or directly to the printer.

Thanks.

Ned Forster
Doug Robbins - 09 Dec 2004 00:36 GMT
Execute the merge to a new document and then with that as the active
document, run a macro containing the following code.  It will send each
letter to the printer as a separate print job so that each gets folded
separately.

Dim i As Long
For i = 1 To ActiveDocument.Sections.Count
   ActiveDocument.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> We are using Word 2003 with a Minolta CF-5001 color copier. The Fiery
> model
[quoted text clipped - 16 lines]
>
> Ned Forster
NedF - 09 Dec 2004 17:13 GMT
Hi Doug,

  Thanks for this.  It is a step in the right direction.  The macro does
indeed break out the letter individually.  However, only the first letter
gets sent to the Fiery queue with the right print settings.  We have
duplexing, tri-fold and 8.5"x11"R paper selected as print options.  The first
page prints fine all the rest print duplex, but lose the tri-fold and
8.5"x11"R settings.  I confirmed this by sending the merge job to the hold
queue and checking the documents.  Any thoughts on why these settings get
lost after the first page?

Ned

> Execute the merge to a new document and then with that as the active
> document, run a macro containing the following code.  It will send each
[quoted text clipped - 26 lines]
> >
> > Ned Forster
NedF - 09 Dec 2004 19:17 GMT
Doug,

   Never mind.  Iwas trying to configure the settings in the merged
document instead of the actual merge document.  When I set the merge document
up correctly it works fine.  Thanks for your help on this.  You have made a
lot of people happy....including the folks who sold us the copier!

Ned

> Execute the merge to a new document and then with that as the active
> document, run a macro containing the following code.  It will send each
[quoted text clipped - 26 lines]
> >
> > Ned Forster
 
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.