how do i print a newletter using the mail merge and staple

[wes]

how do i print a newletter using the mail merge and staple each newsletter?
Each time I do a mail Merge and then try to use the staple function it wants
to staple the entire print job instead of each newsletter.

 

[JoAnn Paules]

Publisher doesn't staple. At least my version doesn't. Hey Brian, how can I
get one of those versions???

Now that I got that out of my system...........Where are you getting this
"Staple" function? It's a printer feature, you need to contact the printer
manufacturer. It's not a Publisher thing.

 

[wes]

this is a publisher problem because publisher is sending the entire mail
merge print job as one document instead of 20 different newsletters

Publisher doesn't staple. At least my version doesn't. Hey Brian, how can I
get one of those versions???

Now that I got that out of my system...........Where are you getting this
"Staple" function? It's a printer feature, you need to contact the printer
manufacturer. It's not a Publisher thing.

--
JoAnn Paules
MVP Microsoft [Publisher]

how do i print a newletter using the mail merge and staple each
newsletter?
Each time I do a mail Merge and then try to use the staple function it
wants
to staple the entire print job instead of each newsletter.

 

[Mary Sauer]

Your printer driver will determine the stapling. What model printer do you have? Most
printer manufacturer's have excellent support documents. If your printer driver is up
to date Publisher will have no problems with the staple function.

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com

this is a publisher problem because publisher is sending the entire mail
merge print job as one document instead of 20 different newsletters

Publisher doesn't staple. At least my version doesn't. Hey Brian, how can I
get one of those versions???

Now that I got that out of my system...........Where are you getting this
"Staple" function? It's a printer feature, you need to contact the printer
manufacturer. It's not a Publisher thing.

--
JoAnn Paules
MVP Microsoft [Publisher]

how do i print a newletter using the mail merge and staple each
newsletter?
Each time I do a mail Merge and then try to use the staple function it
wants
to staple the entire print job instead of each newsletter.

 

[spncity]

Hi Mary and others

Hoping you will know the answer to this - sorry to be pedantic...

Setting up a small gift book to print "two-up". The finished size is 6"
wide by 4" high. Two of these books print in a 6" wide by 9" high space -
with an inch in between for trimming apart the books apart (this is the only
way I can get the book size I want at the price I need from the POD
printer).

So, I'm setting my page to be 6" wide by 9" high.

Here's the question:

Do I see correctly that it is "automatically" allowing me about an eighth of
an inch of bleed on the outside edges of the page? (If this is true -
that's good - that's what I want).

Thanks for replies.

spncity

Your printer driver will determine the stapling. What model printer do you have? Most
printer manufacturer's have excellent support documents. If your printer driver is up
to date Publisher will have no problems with the staple function.

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com

this is a publisher problem because publisher is sending the entire mail
merge print job as one document instead of 20 different newsletters

Publisher doesn't staple. At least my version doesn't. Hey Brian, how can I
get one of those versions???

Now that I got that out of my system...........Where are you getting this
"Staple" function? It's a printer feature, you need to contact the printer
manufacturer. It's not a Publisher thing.

--
JoAnn Paules
MVP Microsoft [Publisher]



how do i print a newletter using the mail merge and staple each
newsletter?
Each time I do a mail Merge and then try to use the staple function it
wants
to staple the entire print job instead of each newsletter.

 

[James Hahn]

This is what Publisher does and AFAIK there is no way around it. When you
specify multiple copies, Publisher manages the multiplication of pages by
itself, and builds a single print job. Procedures that rely on seeing
multiple print jobs, such as stapling, assume it all needs to be stapled as
one job. You need to hunt through the printer driver or the printer front
panel control to see if there is a way of indicating multiple copies that is
an instruction to the printer to repeat the one print job from Publisher
multiple times, then tell Publisher there's only one copy.

If your printer has a collator and you indicate the copies are to be
collated, that might work.

 

[GSBatchelor]

Really Mary. Take off the blinders. This IS a Publisher problem. The printer
driver can only work with what the program sends it, and Publisher isn't
sending the correct information. Publisher has this problem on Canon and
every other machine I've tried it on. The problem is that it sends a group
of about 10 to 20 mail merge documents as a single document. The printer
gets only one end of file command, which happens to be the trigger for the
staple function, and therefore it staples the entire group of documents
together. There is a fix.

This fix courtesy of KATMA, though I actually received it via Ed Bennett:

Open registry using regedit.exe

Go to:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0(see
note)\Publisher\Printing

NOTE: Value for this section is 10.0 for Pub2002, or 11.0 for Pub2003

Create new "string value" called:
NumberOfRecordsPerBatch

Double click and set a value for your batch size to 1

This will merge and send one book to the printer at a time.

Greg.

Your printer driver will determine the stapling. What model printer do you
have? Most printer manufacturer's have excellent support documents. If
your printer driver is up to date Publisher will have no problems with the
staple function.

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com

this is a publisher problem because publisher is sending the entire mail
merge print job as one document instead of 20 different newsletters

Publisher doesn't staple. At least my version doesn't. Hey Brian, how
can I
get one of those versions???

Now that I got that out of my system...........Where are you getting
this
"Staple" function? It's a printer feature, you need to contact the
printer
manufacturer. It's not a Publisher thing.

--
JoAnn Paules
MVP Microsoft [Publisher]



how do i print a newletter using the mail merge and staple each
newsletter?
Each time I do a mail Merge and then try to use the staple function it
wants
to staple the entire print job instead of each newsletter.

 

[Mary Sauer]

I really haven't had any experience with the staple function. I can only assume
somewhere within the documentation of the printer there is a solution. If I gave the
wrong information then I am sorry.

If the staple function works with other applications then it should work with
Publisher... I am glad Ed gave a workaround.

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com

Really Mary. Take off the blinders. This IS a Publisher problem. The printer driver
can only work with what the program sends it, and Publisher isn't sending the
correct information. Publisher has this problem on Canon and every other machine
I've tried it on. The problem is that it sends a group of about 10 to 20 mail merge
documents as a single document. The printer gets only one end of file command,
which happens to be the trigger for the staple function, and therefore it staples
the entire group of documents together. There is a fix.

This fix courtesy of KATMA, though I actually received it via Ed Bennett:

Open registry using regedit.exe

Go to:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0(see note)\Publisher\Printing

NOTE: Value for this section is 10.0 for Pub2002, or 11.0 for Pub2003

Create new "string value" called:
NumberOfRecordsPerBatch

Double click and set a value for your batch size to 1

This will merge and send one book to the printer at a time.

Greg.

Your printer driver will determine the stapling. What model printer do you have?
Most printer manufacturer's have excellent support documents. If your printer
driver is up to date Publisher will have no problems with the staple function.

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com

this is a publisher problem because publisher is sending the entire mail
merge print job as one document instead of 20 different newsletters

:

Publisher doesn't staple. At least my version doesn't. Hey Brian, how can I
get one of those versions???

Now that I got that out of my system...........Where are you getting this
"Staple" function? It's a printer feature, you need to contact the printer
manufacturer. It's not a Publisher thing.

--
JoAnn Paules
MVP Microsoft [Publisher]



how do i print a newletter using the mail merge and staple each
newsletter?
Each time I do a mail Merge and then try to use the staple function it
wants
to staple the entire print job instead of each newsletter.

 

[Mary Sauer]

Is this your own setup, no template involved? Are all the booklets going to be same?

Setup your page 6 x 4. This will give you two to the page, you will only have one
card on your screen. On the arrange menu set the margins to zero. If you want to be
sure of the bleed, setup the page to 6.5 x 4.5.

If you are using perforated cardstock, then the 6 x 4 setup would be used.

Avery has blank templates for Word, these can be adapted to Publisher.
http://www.avery.com/

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com

Hi Mary and others

Hoping you will know the answer to this - sorry to be pedantic...

Setting up a small gift book to print "two-up". The finished size is 6"
wide by 4" high. Two of these books print in a 6" wide by 9" high space -
with an inch in between for trimming apart the books apart (this is the only
way I can get the book size I want at the price I need from the POD
printer).

So, I'm setting my page to be 6" wide by 9" high.

Here's the question:

Do I see correctly that it is "automatically" allowing me about an eighth of
an inch of bleed on the outside edges of the page? (If this is true -
that's good - that's what I want).

Thanks for replies.

spncity

Your printer driver will determine the stapling. What model printer do you have? Most
printer manufacturer's have excellent support documents. If your printer driver is up
to date Publisher will have no problems with the staple function.

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com

this is a publisher problem because publisher is sending the entire mail
merge print job as one document instead of 20 different newsletters

:

Publisher doesn't staple. At least my version doesn't. Hey Brian, how can I
get one of those versions???

Now that I got that out of my system...........Where are you getting this
"Staple" function? It's a printer feature, you need to contact the printer
manufacturer. It's not a Publisher thing.

--
JoAnn Paules
MVP Microsoft [Publisher]



how do i print a newletter using the mail merge and staple each
newsletter?
Each time I do a mail Merge and then try to use the staple function it
wants
to staple the entire print job instead of each newsletter.

 

[Ed Bennett]

While STILL in a state of withdrawal waiting for components to arrive to
repair his dead laptop, Ed notices a message from "Mary Sauer"

I really haven't had any experience with the staple function. I can only
assume somewhere within the documentation of the printer there is a
solution. If I gave the wrong information then I am sorry.

Publisher sends Mail Merged documents in batches, normally of 10. Each
print job that is sent to the printer consists of 10 or so documents.
Stapling in a printer driver is not terribly intelligent. It staples each
print job separately - so if there are 10 documents in the print job, then
it will staple those together. Like if you are printing 10 copies of a
booklet by copying and pasting within a Word document, it would staple all
those together.
By setting the batch size in Publisher so that it prints each merged
document as a separate print job, the printer correctly sees where each
merge document begins and ends, and so staples correctly. This might,
however, decrease performance slightly on the printing, as having so many
print jobs going through on a large merge might slow the computer.

 

[GSBatchelor]

How true, Ed. Fortunately for Wes, he's only trying to print about 20
newsletters. By the sound of it, Publisher was sending the whole batch of
20. If you are trying to do a merge of hundreds of records it will spool
each copy separately, which can really bog things down. 250 copies = 250
print jobs. I do a 12 page newsletter merge of 350 copies. Fortunately I'm
printng to a Canon with a Fiery box and lots of memory and spooling space.
Fortunately, most of my merged documents are straight runs.

I have never had the opportunity to do a bound merge in Word, but it is very
possible the same issue can be found there as well.

 

[Martin]

hi,

I have exactly the same proiblem.

Am using with an HP colour laserjet 9500 and an attached HP print finisher
(folds and staples) using latest drive.

The core problem is it this is that publisher is sending the entire mail
merge print job as one document instead of 20 different booklets.

Word gfets round this by allowing you to specify no of pages in booklet and
then sending each as seperate job.

How can I achieve this in publisher?

Your printer driver will determine the stapling. What model printer do you have? Most
printer manufacturer's have excellent support documents. If your printer driver is up
to date Publisher will have no problems with the staple function.

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com

this is a publisher problem because publisher is sending the entire mail
merge print job as one document instead of 20 different newsletters

Publisher doesn't staple. At least my version doesn't. Hey Brian, how can I
get one of those versions???

Now that I got that out of my system...........Where are you getting this
"Staple" function? It's a printer feature, you need to contact the printer
manufacturer. It's not a Publisher thing.

--
JoAnn Paules
MVP Microsoft [Publisher]



how do i print a newletter using the mail merge and staple each
newsletter?
Each time I do a mail Merge and then try to use the staple function it
wants
to staple the entire print job instead of each newsletter.

 

[Martin]

hi,

multiple copies is not the problem, printers like HP recognise multiple
copies as single jobs so staples etc kick in. Its when your trying to merged
a booklet intoi multiple merged copies where publisher has a problem.

There must be an easy answer to this!

 

[Mary Sauer]

Publications are not individually collated and stapled when you use the mail merge
feature to print to a duplex printer in Publisher 2003 or in Publisher 2002
http://support.microsoft.com/default.aspx?scid=kb;en-us;891904

--
Mary Sauer MS MVP
http://office.microsoft.com/

hi,

I have exactly the same proiblem.

Am using with an HP colour laserjet 9500 and an attached HP print finisher
(folds and staples) using latest drive.

The core problem is it this is that publisher is sending the entire mail
merge print job as one document instead of 20 different booklets.

Word gfets round this by allowing you to specify no of pages in booklet and
then sending each as seperate job.

How can I achieve this in publisher?

Your printer driver will determine the stapling. What model printer do you have?
Most
printer manufacturer's have excellent support documents. If your printer driver is
up
to date Publisher will have no problems with the staple function.

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com

this is a publisher problem because publisher is sending the entire mail
merge print job as one document instead of 20 different newsletters

:

Publisher doesn't staple. At least my version doesn't. Hey Brian, how can I
get one of those versions???

Now that I got that out of my system...........Where are you getting this
"Staple" function? It's a printer feature, you need to contact the printer
manufacturer. It's not a Publisher thing.

--
JoAnn Paules
MVP Microsoft [Publisher]



how do i print a newletter using the mail merge and staple each
newsletter?
Each time I do a mail Merge and then try to use the staple function it
wants
to staple the entire print job instead of each newsletter.

 

[Martin]

Mary,

Thanks for your reply.

Have read the suggest individual record printing idea. Fine if you have
just 20 booklets to do. However I have over 700 A5 booklet (16 pages).
Surprising that word deals with this and publisher doesn't. There must be a
better work round?

Regards

Martin

Publications are not individually collated and stapled when you use the mail merge
feature to print to a duplex printer in Publisher 2003 or in Publisher 2002
http://support.microsoft.com/default.aspx?scid=kb;en-us;891904

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

hi,

I have exactly the same proiblem.

Am using with an HP colour laserjet 9500 and an attached HP print finisher
(folds and staples) using latest drive.

The core problem is it this is that publisher is sending the entire mail
merge print job as one document instead of 20 different booklets.

Word gfets round this by allowing you to specify no of pages in booklet and
then sending each as seperate job.

How can I achieve this in publisher?

Your printer driver will determine the stapling. What model printer do you have?
Most
printer manufacturer's have excellent support documents. If your printer driver is
up
to date Publisher will have no problems with the staple function.

--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.msauer.mvps.org/
news://msnews.microsoft.com
this is a publisher problem because publisher is sending the entire mail
merge print job as one document instead of 20 different newsletters

:

Publisher doesn't staple. At least my version doesn't. Hey Brian, how can I
get one of those versions???

Now that I got that out of my system...........Where are you getting this
"Staple" function? It's a printer feature, you need to contact the printer
manufacturer. It's not a Publisher thing.

--
JoAnn Paules
MVP Microsoft [Publisher]



how do i print a newletter using the mail merge and staple each
newsletter?
Each time I do a mail Merge and then try to use the staple function it
wants
to staple the entire print job instead of each newsletter.

 

[Chuck Davis]

Mary,

Thanks for your reply.

Have read the suggest individual record printing idea. Fine if you have
just 20 booklets to do. However I have over 700 A5 booklet (16 pages).
Surprising that word deals with this and publisher doesn't. There must be
a
better work round?

Regards

Martin

Martin,
Place your file on a USB Flash drive and take it (or e-mail) to your local
Office Depot (or similar) they will make your copies, (I suggest the outer
sheet be a different color) fold, staple and trim for a reasonable price. If
your file is large, create a PDF using Adobe Acrobat (not the Reader) or a
free program from http://www.win2pdf.com or http://www.primopdf.com

You will save a lot of time and agravation.