mail merge trouble....

[RealEstateLady]

I have created a publication in Publisher (8 page booklet with fold and
staple). I want to print it with the addresses (imported from excel) already
on it instead of using seperate labels. How do I do this and have it
duplicate my document with different addresses instead of add pages to my
existing publication? My publication is now 1275 pages long... thanks for
any help you can offer.

 

[Mary Sauer]

You need to use one text box, insert the fields in that text box and merge.

Create a mail merge
http://office.microsoft.com/en-us/assistance/HP052584251033.aspx

Troubleshoot mail merge in Publisher
http://office.microsoft.com/en-us/assistance/HP030662451033.aspx

 

[RealEstateLady]

I have done that. And it works successfully for all 182 addresses. The
problem is that it prints them all as ONE publication instead of 182 separate
booklets. [I have an 8 page booklet ( 2--8.5 x 11 pages folded in half)].
So my printer folds and staples them all together instead of individually.
What do I do in Publisher to get them to be all separate booklets so that my
printer can fold and staple as 182 "SEPARATE" 8 PAGE BOOKLETS with
addresses???



Thanks for the reply.

 

[Mary Sauer]

This article addresses your issue. I should have referenced it before.

Publications are not individually collated and stapled when you use the mail
merge feature to print in Publisher 2003, Publisher 2002 or in Publisher 2000
http://support.microsoft.com/kb/891904/en-us

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

http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx

I have done that. And it works successfully for all 182 addresses. The
problem is that it prints them all as ONE publication instead of 182 separate
booklets. [I have an 8 page booklet ( 2--8.5 x 11 pages folded in half)].
So my printer folds and staples them all together instead of individually.
What do I do in Publisher to get them to be all separate booklets so that my
printer can fold and staple as 182 "SEPARATE" 8 PAGE BOOKLETS with
addresses???



Thanks for the reply.

I have created a publication in Publisher (8 page booklet with fold and
staple). I want to print it with the addresses (imported from excel) already
on it instead of using seperate labels. How do I do this and have it
duplicate my document with different addresses instead of add pages to my
existing publication? My publication is now 1275 pages long... thanks for
any help you can offer.

 

[RealEstateLady]

Thanks. It stinks but it helps. No more hours spent trying to figure
this one out!!! I had already tried the same number in from and to boxes and
that seemed to work but I was hoping for an easier way. :-( Take care.
Thanks again, Mary.

This article addresses your issue. I should have referenced it before.

Publications are not individually collated and stapled when you use the mail
merge feature to print in Publisher 2003, Publisher 2002 or in Publisher 2000
http://support.microsoft.com/kb/891904/en-us

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx

I have done that. And it works successfully for all 182 addresses. The
problem is that it prints them all as ONE publication instead of 182 separate
booklets. [I have an 8 page booklet ( 2--8.5 x 11 pages folded in half)].
So my printer folds and staples them all together instead of individually.
What do I do in Publisher to get them to be all separate booklets so that my
printer can fold and staple as 182 "SEPARATE" 8 PAGE BOOKLETS with
addresses???



Thanks for the reply.

I have created a publication in Publisher (8 page booklet with fold and
staple). I want to print it with the addresses (imported from excel) already
on it instead of using seperate labels. How do I do this and have it
duplicate my document with different addresses instead of add pages to my
existing publication? My publication is now 1275 pages long... thanks for
any help you can offer.

 

[Ed Bennett]

Thanks. It stinks but it helps. No more hours spent trying to figure
this one out!!! I had already tried the same number in from and to boxes and
that seemed to work but I was hoping for an easier way. :-( Take care.

Did you try Method 1?

 

[RealEstateLady]

Hi Ed. No, I didn't try method one. It sounded like I could really screw up
some stuff so I was going to do Method 2. I am printing about 600 of these
so it would be helpful to be able to do that. Any suggestions???? :-0

 

[Ed Bennett]

Hi Ed. No, I didn't try method one. It sounded like I could really screw up
some stuff so I was going to do Method 2. I am printing about 600 of these
so it would be helpful to be able to do that. Any suggestions???? :-0

Any article on the Knowledge Base that suggests editing the Registry has
to carry that disclaimer. If you're careful and only touch the value
specified in the article, you should be fine. I have advocated that
solution on the newsgroups in the past and was responsible for having
that particular method included in the article. It allows you to press
print for all 600 records, and Publisher will automatically send each
one as a separate print job.