Re: How to mail merge with a folder option?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: NedF (NedF_at_discussions.microsoft.com)
Date: 12/09/04 

Date: Thu, 9 Dec 2004 09:13:07 -0800

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

"Doug Robbins" wrote:

> 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
>
> --
> 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
> "NedF" <NedF@discussions.microsoft.com> wrote in message
> news:9749DFD0-B4B6-4B75-B45B-034A5F65C552@microsoft.com...
> > 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
>
>
>

Relevant Pages

  • Re: merge a 1600 record datasource into 1600 separate documents
    ... ' Macro created by Doug Robbins to save each letter created by a mailmerge ... creating a separate catalog type mailmerge maindocument which creates a word ... ' Throw Away Macro created by Doug Robbins ...
    (microsoft.public.word.vba.general)
  • Re: How do I save a mail merge form letter to separate files?
    ... ' Macro created by Doug Robbins to save each letter created by a mailmerge ... here's a method that I have used that involves creating a separate ... ' Throw Away Macro created by Doug Robbins ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Convert 200-page word doc to 200 separate docs
    ... ' Macro created 07-09-04 by Doug Robbins to save each page of a document ... ' as a separate file with the name being the lastword of the first paragraph ... Set NewDoc = Documents.Add ...
    (microsoft.public.word.vba.general)
  • Macro to Break into Seperate Columns
    ... I have a text file I'm working with that I need to break into separate ... I cannot use the standard Text to Columns since ... I'd like to base a macro on. ... based on the below settings. ...
    (microsoft.public.excel.programming)
  • RE: Display revision bars only
    ... "Lene Fredborg" wrote: ... Track Changes Option settings it ... I still get revision bars and no inline markup. ... If you want to make a macro that sets your "normal" track changes settings, ...
    (microsoft.public.word.docmanagement)