A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Publisher
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Postcard Mail Merge - 4 per page difficulties



 
 
Thread Tools Display Modes
  #1  
Old May 3rd, 2009, 06:14 PM posted to microsoft.public.publisher
office mom
external usenet poster
 
Posts: 1
Default Postcard Mail Merge - 4 per page difficulties

I am trying to merge 50 records onto the postcards I have created (4 to a
page/landscape) When I print them, they all merge, but you get four of the
exact same address per page. How do I have one address on each postcard
instead of 4 of each address. I'm going crazy! I read over past questions
and it is not just a glitch in print preview, it actually does print 4. I
just did it! Can I change a setting somewhere to fix this?

I also tried creating my own four per page design with my own merge boxes,
but I can not find a way to add the next record field you need to get it
to go to the next box. It prints four of the same per page there as well!

HELP. I hope someone know the answer to this

  #2  
Old May 3rd, 2009, 06:57 PM posted to microsoft.public.publisher
office mom[_2_]
external usenet poster
 
Posts: 1
Default Postcard Mail Merge - 4 per page difficulties

OK - I just spent 45 minutes reading through all the old posts and trying
different things. Finally, I went to WORD and made the back of the postcards
using an Avery Label and now I will print the fronts in Publisher by just
turning the paper over for the printer. This whole thing is insane.
Hopefully Microsoft will fix this in future versions of Publisher. It would
be sweet if it worked well by merging 4 records on one page or by allowing
you to insert your own "next field" merge code. (Word Perfect lets you do
that.)

Thanks for all of your help and suggestions through past entries!

"office mom" wrote:

I am trying to merge 50 records onto the postcards I have created (4 to a
page/landscape) When I print them, they all merge, but you get four of the
exact same address per page. How do I have one address on each postcard
instead of 4 of each address. I'm going crazy! I read over past questions
and it is not just a glitch in print preview, it actually does print 4. I
just did it! Can I change a setting somewhere to fix this?

I also tried creating my own four per page design with my own merge boxes,
but I can not find a way to add the next record field you need to get it
to go to the next box. It prints four of the same per page there as well!

HELP. I hope someone know the answer to this

  #3  
Old May 3rd, 2009, 07:20 PM posted to microsoft.public.publisher
Ed Bennett
external usenet poster
 
Posts: 1,656
Default Postcard Mail Merge - 4 per page difficulties

office mom wrote:
OK - I just spent 45 minutes reading through all the old posts and trying
different things. Finally, I went to WORD and made the back of the postcards
using an Avery Label and now I will print the fronts in Publisher by just
turning the paper over for the printer. This whole thing is insane.
Hopefully Microsoft will fix this in future versions of Publisher.


This DOES work in all versions of Publisher I've tried it in. You have
to design a SINGLE postcard on screen, and then set the Page Setup such
that it repeats the design across the page. PROVIDED you design it like
this, then the Print Preview showing the same details is a bug (it reads
the first record and puts it everywhere just to give an idea of the
design), and the printout should be fine.

Where problems arise is when you try to design a single sheet of cards
at once. This is obviously doomed to failure since there is no sensible
way of telling Publisher where to switch records.

by allowing
you to insert your own "next field" merge code. (Word Perfect lets you do
that.)


I always puzzle when people ask where this is in Publisher, or suggest
it be added. How on Earth would it be done?! It makes perfect sense in a
linear text-oriented application - once the Next Record is hit,
the current record is incremented. However, in a frame-oriented
application like Publisher, which field codes would come before and after?

--
Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org
  #4  
Old June 16th, 2009, 02:00 PM posted to microsoft.public.publisher
MaggieDonuts
external usenet poster
 
Posts: 12
Default Postcard Mail Merge - 4 per page difficulties

I had same problem and realized that when you click "Print" you must click on
the box that says "Mutiple PAGES per sheet" and not Multiple COPIES per
sheet. That is how you get the 4 different addresses on a 4 up page

"office mom" wrote:

I am trying to merge 50 records onto the postcards I have created (4 to a
page/landscape) When I print them, they all merge, but you get four of the
exact same address per page. How do I have one address on each postcard
instead of 4 of each address. I'm going crazy! I read over past questions
and it is not just a glitch in print preview, it actually does print 4. I
just did it! Can I change a setting somewhere to fix this?

I also tried creating my own four per page design with my own merge boxes,
but I can not find a way to add the next record field you need to get it
to go to the next box. It prints four of the same per page there as well!

HELP. I hope someone know the answer to this

  #5  
Old October 1st, 2009, 04:16 AM posted to microsoft.public.publisher
Patana Banana
external usenet poster
 
Posts: 1
Default Postcard Mail Merge - 4 per page difficulties

It works, but, boy, did I get a work out on this issue!

"Ed Bennett" wrote:

office mom wrote:
OK - I just spent 45 minutes reading through all the old posts and trying
different things. Finally, I went to WORD and made the back of the postcards
using an Avery Label and now I will print the fronts in Publisher by just
turning the paper over for the printer. This whole thing is insane.
Hopefully Microsoft will fix this in future versions of Publisher.


This DOES work in all versions of Publisher I've tried it in. You have
to design a SINGLE postcard on screen, and then set the Page Setup such
that it repeats the design across the page. PROVIDED you design it like
this, then the Print Preview showing the same details is a bug (it reads
the first record and puts it everywhere just to give an idea of the
design), and the printout should be fine.

Where problems arise is when you try to design a single sheet of cards
at once. This is obviously doomed to failure since there is no sensible
way of telling Publisher where to switch records.

by allowing
you to insert your own "next field" merge code. (Word Perfect lets you do
that.)


I always puzzle when people ask where this is in Publisher, or suggest
it be added. How on Earth would it be done?! It makes perfect sense in a
linear text-oriented application - once the Next Record is hit,
the current record is incremented. However, in a frame-oriented
application like Publisher, which field codes would come before and after?

--
Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org

  #6  
Old October 1st, 2009, 04:28 PM posted to microsoft.public.publisher
MaggieDonuts
external usenet poster
 
Posts: 12
Default Postcard Mail Merge - 4 per page difficulties

Glad I could be of help, I know since I also spent hours trying to get it
right...but the client responses I get make it worthwhile!

"Patana Banana" wrote:

It works, but, boy, did I get a work out on this issue!

"Ed Bennett" wrote:

office mom wrote:
OK - I just spent 45 minutes reading through all the old posts and trying
different things. Finally, I went to WORD and made the back of the postcards
using an Avery Label and now I will print the fronts in Publisher by just
turning the paper over for the printer. This whole thing is insane.
Hopefully Microsoft will fix this in future versions of Publisher.


This DOES work in all versions of Publisher I've tried it in. You have
to design a SINGLE postcard on screen, and then set the Page Setup such
that it repeats the design across the page. PROVIDED you design it like
this, then the Print Preview showing the same details is a bug (it reads
the first record and puts it everywhere just to give an idea of the
design), and the printout should be fine.

Where problems arise is when you try to design a single sheet of cards
at once. This is obviously doomed to failure since there is no sensible
way of telling Publisher where to switch records.

by allowing
you to insert your own "next field" merge code. (Word Perfect lets you do
that.)


I always puzzle when people ask where this is in Publisher, or suggest
it be added. How on Earth would it be done?! It makes perfect sense in a
linear text-oriented application - once the Next Record is hit,
the current record is incremented. However, in a frame-oriented
application like Publisher, which field codes would come before and after?

--
Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.