mail merged data, booklet mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

peter - 01 Sep 2005 15:57 GMT

I am printing an 8-page document in booklet mode.
It contains mail merged data on several pages; ie. an account number.
It prints fine except that the reverse of each sheet contains the wrong data.
The front of the 1st Sheet has the 1st account number but the reverse
contains the last account number. the second copy of sheet 1 has the second
account on the front and the next-to-last account no. on the reverse.
I've tried changing the collation settings to no avail. I always get the
same results.
I have several hundred of these & a manual collation would probably get
messed up.

Reply to this Message

Doug Robbins - 01 Sep 2005 17:59 GMT

If you execute the merge to a new document and then run the following macro
on that
document and it will send each letter to the printer as a separate print job
which may overcome your problem:

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am printing an 8-page document in booklet mode.
> It contains mail merged data on several pages; ie. an account number.
[quoted text clipped - 8 lines]
> I have several hundred of these & a manual collation would probably get
> messed up.

Reply to this Message

peter - 01 Sep 2005 22:03 GMT

Hmmm.. maybe, but this is for a pretty challenged user. I'd have to do it
every time they wanted to mail-merge some forms!
AAcckk!

> If you execute the merge to a new document and then run the following macro
> on that
[quoted text clipped - 20 lines]
> > I have several hundred of these & a manual collation would probably get
> > messed up.

Reply to this Message

Rate this thread: