4 per page postcards merge print problmes

Yes, and when I print the resulting 'publication' I get four postcards per
page BUT they ALL have the same NAME and ADDRESS on them.

Oh Well...

"Mary Sauer" wrote:

Have you tried to save as a publication in step five?

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

"jwb" wrote in message
...
Mary, thanks again.

I will continue to research the help links you mentioned, but I think I have
been to them all.

Again, my problem isn't printing, I can 'merge to print' what Publisher
won't do correctly is 'merge to file' When I try to print the resulting
'merge to file' I get four of the same records on the same sheet. It would
be nice to 'merge to file' be able to review and edit there, THEN print.

I guess there is a bug or a misunderstanding on my part. For now I'll be
content to 'merge to print'.

THanks for the effort.

JWB

"Mary Sauer" wrote:

Hello again JWB,

There is an enormous amount of help either from the Office site or within
Publisher's help.

Mail and catalog merge
http://office.microsoft.com/en-us/pu...524751033.aspx

You can merge from Word, Access, Excel, Publisher and other data programs.

Mail and Catalog Merge data sources used in Publisher
http://office.microsoft.com/en-us/pu...713471033.aspx

As I mentioned before, there is a bug in Publisher that will show all cards
being the same in print preview, but they won't print all the same. Do a
sample
print first.


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

"jwb" wrote in message
...
Rocket Science I actually do understand, Publisher is what I am having
problems with. I re-read your answers and the article you sent and I don't
see any reference to using an Access database instead of the Excel
spreadsheet.

I could easily convert my database into an Access database and use that to
merge from, did I miss something? Would that solve the problem I am having
with all FOUR records per sheet having the same name on them when I 'merge
to
document"?

Thanks again for the help. This is always a GREAT resource.

JWB

"Mary Sauer" wrote:

Create a data list within Publisher. By default Publisher saves the data
as
an
Access database. It is not rocket science.


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

"jwb" wrote in message
...
Wow!! that seems like way more trouble than it is worth.

I can continue to just PRINT directly from the merged publisher
document.
The disadvantage is I can't edit the cards before I print. However to
cut
and past and cut and paste and ... to get 4 cards per row in my excel
data.... well that is not worth that.

And as for the question of how many cards are on my screen before I do
the
merge? ONE. I create a document that is four copies per page, a basic
option
available in publisher and then I merge to an excel spread sheet that
has
400
rows of addresses, ONE address per row.

Publisher can obviously created the document and PRINT it, it just can't
save it. Once again, I am AMAZAED at such a basic thing for a MAIN
STREAM
backbone program like publisher for Microsoft, how much trouble it is
for
it
to handle it.

You would think the boys and girls at MS would have figured this bug out
by
now.

Based on the number of threads with the SAME problem, I'm not the only
person creating postcards and merging address fields using publisher...

Thanks for the suggestion.

JWB

"No Spam, man" wrote:

The parentheses above should have read, "(100 addressees divided by
4)".

Can you send me your data?
I will see if I get the same result.
mary-sauer at columbus.rr.com

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

"jwb" wrote in message
...
Yes, and when I print the resulting 'publication' I get four postcards per
page BUT they ALL have the same NAME and ADDRESS on them.

Oh Well...

"Mary Sauer" wrote:

Have you tried to save as a publication in step five?

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

"jwb" wrote in message
...
Mary, thanks again.

I will continue to research the help links you mentioned, but I think I
have
been to them all.

Again, my problem isn't printing, I can 'merge to print' what Publisher
won't do correctly is 'merge to file' When I try to print the resulting
'merge to file' I get four of the same records on the same sheet. It would
be nice to 'merge to file' be able to review and edit there, THEN print.

I guess there is a bug or a misunderstanding on my part. For now I'll be
content to 'merge to print'.

THanks for the effort.

JWB

"Mary Sauer" wrote:

Hello again JWB,

There is an enormous amount of help either from the Office site or within
Publisher's help.

Mail and catalog merge
http://office.microsoft.com/en-us/pu...524751033.aspx

You can merge from Word, Access, Excel, Publisher and other data programs.

Mail and Catalog Merge data sources used in Publisher
http://office.microsoft.com/en-us/pu...713471033.aspx

As I mentioned before, there is a bug in Publisher that will show all
cards
being the same in print preview, but they won't print all the same. Do a
sample
print first.


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

"jwb" wrote in message
...
Rocket Science I actually do understand, Publisher is what I am having
problems with. I re-read your answers and the article you sent and I
don't
see any reference to using an Access database instead of the Excel
spreadsheet.

I could easily convert my database into an Access database and use that
to
merge from, did I miss something? Would that solve the problem I am
having
with all FOUR records per sheet having the same name on them when I
'merge
to
document"?

Thanks again for the help. This is always a GREAT resource.

JWB

"Mary Sauer" wrote:

Create a data list within Publisher. By default Publisher saves the
data
as
an
Access database. It is not rocket science.


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

"jwb" wrote in message
...
Wow!! that seems like way more trouble than it is worth.

I can continue to just PRINT directly from the merged publisher
document.
The disadvantage is I can't edit the cards before I print. However
to
cut
and past and cut and paste and ... to get 4 cards per row in my excel
data.... well that is not worth that.

And as for the question of how many cards are on my screen before I
do
the
merge? ONE. I create a document that is four copies per page, a
basic
option
available in publisher and then I merge to an excel spread sheet that
has
400
rows of addresses, ONE address per row.

Publisher can obviously created the document and PRINT it, it just
can't
save it. Once again, I am AMAZAED at such a basic thing for a MAIN
STREAM
backbone program like publisher for Microsoft, how much trouble it is
for
it
to handle it.

You would think the boys and girls at MS would have figured this bug
out
by
now.

Based on the number of threads with the SAME problem, I'm not the
only
person creating postcards and merging address fields using
publisher...

Thanks for the suggestion.

JWB

"No Spam, man" wrote:

The parentheses above should have read, "(100 addressees divided by
4)".