Publisher Problem: Printing a mail merge booklet on Kyocera Printe

[Erin Cox-Holmes]

We have run into an issue when printing a malmerge document from MS Publisher
2007 to a Kyocera printer. This is an 8 page newsletter which is supposed to
be assembled as a booklet (folded and stapled) on a Kyocera KM-3232. The
mailmerge address with a barcode is inserting correctly into publisher, with
the data source an excel spreadsheet.

But on the Kyocera the booklet is drawing the maximum pages (40) before
folding and stapling. Kyocera says the problem is in Publisher. I can't find
any information in publsiher to figure out how to fix it.

The document prints correctly as one document per fold/staple when the merge
codes are deleted.

Any ideas?

 

[Ed Bennett]

But on the Kyocera the booklet is drawing the maximum pages (40) before
folding and stapling. Kyocera says the problem is in Publisher. I can't find
any information in publsiher to figure out how to fix it.

The document prints correctly as one document per fold/staple when the merge
codes are deleted.

Publisher by default sets the mail merge batch size to 10 documents per
print job (to avoid swamping the printer with hundreds of print jobs or
one impossibly large one).

In previous versions, this was configurable using a registry hack
(detailed here: http://ed.mvps.org/Static.aspx?=Publisher/registryfix),
but this currently does not work in Publisher 2007. The Publisher team
are aware of this; I'm not sure what (if anything) they're doing about it.

 

[Erin Cox-Holmes]

Thanks Ed.

So, if one has generated an 8 page newsletter in Publisher, and needs to
merge it with addess and barcode on the final page of the document, and then
send this document to the copier to be printed and stapled, what does one do?
We have the entire MS Office 2007 premium suite, plus acrobat professional,
if any of those apps will accept the merged document as discrete documents.

Is the only other solution to print labels instead of doing the merge on the
document? (It prints and staples correctly w/out the merge).
thanks,
Erin Cox-Holmes

 

[Erin Cox-Holmes]

bumping this up after the long weekend. still hoping for advice on an app
which will permit stapling mail merge newsletters. We have all of MS Office
Enterprise and Adobe Acrobat available.

 

[Ed Bennett]

bumping this up after the long weekend. still hoping for advice on an app
which will permit stapling mail merge newsletters. We have all of MS Office
Enterprise and Adobe Acrobat available.

The possible solutions are described here:
http://support.microsoft.com/kb/891904

(It may also be possible to use VBA to accomplish this, I'm not entirely
certain.)

Hopefully SP1 will bring some change in this area...

 

[Erin Cox-Holmes]

thanks, Ed. Do you know if the PDF solution works in MS Publisher 2007? I'm
guessing all the other solutions won't work.

 

[Ed Bennett]

thanks, Ed. Do you know if the PDF solution works in MS Publisher 2007? I'm
guessing all the other solutions won't work.

Solution 1 is the one I've documented on my site which definitely
doesn't work.

Solutions 2 and 3 will work, but are completely impractical unless
you're doing many documents.

Solution 4 I'm not sure about. It's probably easiest just to test on
some sample data and see whether you get one PDF per record or multiple
records in a single PDF.