Business Card - Merge - Don't want each record on same page...

[Chad Richardson]

....I want it to come out like the print preview....

I am creating business cards via a merge in v2003. I have an excel record
source with 7 rows in it. When I print, I want 1 page to print, 10 up, with
all 10 coming from the same record in Excel. Then page 2 to have all 10 cards
with data from record 2, etc.

Now I am getting just 1 page with 7 cards and each card is from a different
record in Excel.

Thanks for any info...

 

[Mary Sauer]

If you have setup the Excel with 7 fields and nothing else, open the merge wizard in
Publisher setup your business card (you should have only one card on your screen),
add 6 additional pages, put a different field on each page. This should work.

 

[Mary Sauer]

You may have to setup each card in a separate file. It shouldn't take very long.
Might try Word's merge, it is pretty good.

 

[Ron Cohen]

This is really easy to do. First, forget about using any wizards (I'm not
referring to the mail merge wizard however) or templates - they just make
things more tedious than necessary.

Start with a blank page and create a text frame equal to a business card.
Position the frame so it's in the same spot as it will be printed on the
sheet. Most likely it will be .5 down and .5 from the left margin.
Add the fields from the data source as you normally would and then continue
creating this single card with whatever text or graphics you may want.
Now copy and paste the completed card (frame) nine times so that you now
have a single sheet with ten identical images. Obviously these frames have
to be positioned relative to the first frame.
That's all there is to it.

Note: This situation is the reverse of what so many trying to use mail merge
encounter when trying to print multi-up sheets such as post cards. They do
not want the data repeated in each frame. That situation is also easy to
resolve.