Re: Mail Merge Help

If your printer is PCL or Postscript compatible and using the appropriate
driver then yes the information should be in the book or on the
manufacturer's web site.

As for the macro referred to in the other branch of the thread, then
provided you have the tray allocations set for the various sections, merge
to a new document and then see if the following macro does the 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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



blackX wrote:
Okay I will look into this. IF the print does accept PCL, then will
it tell the code in the book?

"Graham Mayor" wrote:

You *MAY* be able to address the paper tray issue with PRINT fields,
if your printer accepts PCL or Postscript commands. A PRINT field
is simply a type of field that allows you to send instructions
directly to the printer.
e.g. for horizontal duplex (PCL) you would insert the following
field : { PRINT 27"&l2S" }
Lookup the commands to select the trays in your printer manual.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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



blackX wrote:
I figured so. I like your idea on for the margins and I think that
will work. I am trying to automate as much of this as I can. I
started with 16 different letters and 16 data sources and I have got
it down to 8 letters and 1 data source. If I can solve the tray
selection problem that I will have this whole process down to a few
clicks. If not then she will just have to filter the query inside
of word and do the seperate projects individually. Logically you
would think that it could be as simple as lettercode1,2,3,4=tray1,
lettercode5,6=tray2, lettercode7,8=tray3 but I guess I am just
wishing. I will check out the link you provided and I appreciate
your help.

"Peter Jamieson" wrote:

My personal opinion is that you will find it extremely difficult to
solve either of the two problems you mention using a single merge
in Word, and it is likely to be much simpler and more maintainable
to create a number of mrges, each of which selects the records it
needs, uses a single layout, and specifies a particular paper
source.

If you want to attack the problem of several layouts in a single
merge, you're in luck, because there is a current discussion on
this subject - look for the conversation titled "Mergefields, IF
statements and section breaks" started by JAnderson on 16 July
2008. I cannot say that it will solve your margin problems - in
the past, I have not been able to come up with a merge that will
do that, but that does not mean that it cannot be done.

As for the paper tray problem, if you base a solution on the
results of the discussion I mentioned above, then you have also to
work out how to associate each output section with a different
tray. IMO that is another good reason to find a different
approach:-)

On the specific subject of the margins, if you are the author of
all the layouts you are using, you may be able to make things
slightly easier for yourself by keeping to a fixed set of Word
page layouts, but e.g. modifying all your paragraph layouts so
that the documents that need a 0.5in margin use a 0.3in margin but
al have indents of
0.2in.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"blackX" <blackX@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:44D5F48F-0D8E-438D-8E3C-2E129D95C032@xxxxxxxxxxxxxxxx
any ideas on either of these? Again, any help is much
appreciated.

"blackX" wrote:

I have a total of 8 different letters that needs to merged with a
single data
source. Using include text I was able to do this. My first
problem is that
4 of the letters need to be printed using the paper in tray 1 and
the other 4
need to use the paper in tray 2. My second problem is that some
of the letters use a .5" margin and the rest use a .3" margin.
Can I conditionally
set the margins in the Main.doc so the letter margins are
correct? Thanks


.

Relevant Pages

  • Re: Is this possible...?
    ... initials formatted as hidden within a paragraph that will be deleted, ... Word MVP web site http://word.mvps.org ... letters as a basis for new ones and create proper templates. ...
    (microsoft.public.word.newusers)
  • Re: Is this possible...?
    ... I would love to do that, Graham. ... Word MVP web site http://word.mvps.org ... letters as a basis for new ones and create proper templates. ...
    (microsoft.public.word.newusers)
  • Re: Is this possible...?
    ... Word MVP web site http://word.mvps.org ... It would be better if they would just change the reference but "it ... top of letters is a reference made up of the initials, ...
    (microsoft.public.word.newusers)
  • Re: Mail Merge Help
    ... Word MVP web site http://word.mvps.org ... provided you have the tray allocations set for the various sections, ... While Counter < Letters ... that the documents that need a 0.5in margin use a 0.3in margin ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail Merge Help
    ... Word MVP web site http://word.mvps.org ... provided you have the tray allocations set for the various sections, ... While Counter < Letters ... that the documents that need a 0.5in margin use a 0.3in margin ...
    (microsoft.public.word.mailmerge.fields)
Loading