Re: Printing from alternating trays

Tech-Archive recommends: Fix windows errors by optimizing your registry



Mail merge often cannot cope with such print demands. The answer in such
circumstances is to use a macro to treat each 'letter' as a separate print
job.

Sub SplitMergeLetterToPrinter()
' splitter Macro
' Macro created 16-08-98 by Doug Robbins to print each letter created by a
' mailmerge as a separate file.
'
Letters = ActiveDocument.Sections.Count
Counter = 1
While Counter < Letters
ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _
From:="s" & Format(Counter), to:="s" & Format(Counter)
Counter = Counter + 1
Wend
End Sub

http://www.gmayor.com/installing_macro.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


rc51wv wrote:
I have 150 letts that consist of 4 pages. They were created with mail
merge and then all placed into one document so when you scroll down,
once you hit the first page of the next letter, it shows pg1 and not
pg5, pg9, etc... The first page needs to be on paper with a letter
head.

What I'm doing now is printing to an HP 9050 and setting the machine
to print pg1 from tray 2 with the letter head and the rest of the
pages through tray 3 with the plain paper. The problem is that it
only prints the very first page of the entire document on the letter
head and when pg1 of the next letter comes up, it's printed on plain
paper from tray 3.

What am I doing wrong and how do I fix this?


.



Relevant Pages

  • Re: Mail Merge Help
    ... It's certainly worth trying the field option that Graham mentioned, as it's simpler if it works, but it only works with some printers, /and/ you have to be able to find out what the correct tray selection sequences are. ... Otherwise you would probably need to run a macro post-merge, and that macro would need to have some way of knowing which document should use paper from which tray, because by the time the merge is complete, that information is lost. ... assuming you can handle the formatting issues (left margin etc.) ... >> If you want to attack the problem of several layouts in a single>> merge, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: help with macros
    ... Thanks for the document giving me an option for selecting the tray. ... macro you gave me. ... 'Pick the label type ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.newusers)
  • Re: Macros for All users in a lab
    ... I can lower or change settings for security too if needed. ... The small code works as a macro. ... change the tray? ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.vba.general)
  • Re: Problems with Macros
    ... Dim sCurrentPrinter As String ... ActivePrinter = "Put the name of the required printer here" ... .DefaultTray = "Set the tray option here" ... Anyway - macro seems to record okay, ...
    (microsoft.public.word.docmanagement)
  • Re: Page Setup using a macro and Word 2003
    ... G'day Scott Schaffer, ... set to a different tray. ... loaded with first and second page letterhead paper. ... When a letterhead copy and white copy are needed, they use the macro, ...
    (microsoft.public.word.vba.general)