Hi all
I've got a somewhat specific problem that I'm sure must have an answer, but I'll be blowed if I know how to approach it.
We have a print-and-post-room that is set up with plenty of hardware to make bulk mailing easier (folding machines, envelope-stuffers, etc.). However, we need to print around 1000 20-page, A4 booklets where each one has personalised content. Each booklet is 5 sheets of A3 stapled and folded to make the 20 page A4 booklet. These are personalised by using a mail-merge template.
The problem we have is that whilst the booklet machine can identify the same file being printed 1000 times to produce 1000 separate booklets, a merge of 1000 different records is treated as a single file when sent to print, and would come out as a single book containing all 1000 booklets.
The manual override to this problem is to send each booklet to the printer individually, but this requires someone to sit at the computer saying "print pages 1-20, print pages 21-40... print pages 4001-4020, etc.). My first thought would be a script that automates this, sending 1000 print jobs of 20 pages each. If I were doing it in MS Excel I could probably find my way around this via a macro (though my VBA isn't great), but I don't know where to start for MS Word.
Suggestions?
Stuart
I've got a somewhat specific problem that I'm sure must have an answer, but I'll be blowed if I know how to approach it.
We have a print-and-post-room that is set up with plenty of hardware to make bulk mailing easier (folding machines, envelope-stuffers, etc.). However, we need to print around 1000 20-page, A4 booklets where each one has personalised content. Each booklet is 5 sheets of A3 stapled and folded to make the 20 page A4 booklet. These are personalised by using a mail-merge template.
The problem we have is that whilst the booklet machine can identify the same file being printed 1000 times to produce 1000 separate booklets, a merge of 1000 different records is treated as a single file when sent to print, and would come out as a single book containing all 1000 booklets.
The manual override to this problem is to send each booklet to the printer individually, but this requires someone to sit at the computer saying "print pages 1-20, print pages 21-40... print pages 4001-4020, etc.). My first thought would be a script that automates this, sending 1000 print jobs of 20 pages each. If I were doing it in MS Excel I could probably find my way around this via a macro (though my VBA isn't great), but I don't know where to start for MS Word.
Suggestions?
Stuart