How do I separate mail merge documents(pcl code), so each documen.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

psy UK - 24 Sep 2004 09:33 GMT

Using the hp 3000stacker to staple documents, I want to print a mail merge
letter and have each letter stapled. The printer only sees the print job as
one document. I assume a PCL command is needed embedded in word to tell the
printer to print each document and staple it.

Reply to this Message

Doug Robbins - 24 Sep 2004 10:01 GMT

Execute the merge to a document and then run the following macro over that
document:

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

> Using the hp 3000stacker to staple documents, I want to print a mail merge
> letter and have each letter stapled. The printer only sees the print job
> as
> one document. I assume a PCL command is needed embedded in word to tell
> the
> printer to print each document and staple it.

Reply to this Message

Archie - 04 Nov 2004 12:47 GMT

I have used Doug Robbins macro but I am also printing a Sequential Number for
each stapled document . For some reason when this document prints , it starts
the numbering sequence at 12 then prints numbers 1-11 at the end of the
printed mail meged document . Is their a reason for this and can this
document be presented to print from 1 as the start ,instead of 12 .

> Execute the merge to a document and then run the following macro over that
> document:
[quoted text clipped - 10 lines]
> > the
> > printer to print each document and staple it.

Reply to this Message