How do I merge two data fields on 1 page?

[ajw]

I am trying to use Publisher to create medium sized front and back table
tents (the name needs to appear on the front and back) I am usign Avery 5305
Card Stock. 2 cards can be printed per piece of card stock. I want to use
use a mail merge from excell spread sheet. The name repeats twice for each
card (front and back, the second appears upside down). I can successfully
merge the data into the form, and have it appear the way I want it to, but I
cannot get it to print two pages (of data) on the one page. Instead of
printing the name field twice, it prints it four times. I've tried changing
the layout, setting up separate pages. I found a template for the card 5305
in Word, downloaded it from the Avery site but I can't figure out how to set
up the form, no way to see the coding or add Borders, etc.
Please help. Can you do a merge in Powerpoint?

 

[Mary Sauer]

Avery has two different templates for your card number. Publisher has the template in
the label list. I tried merging with this setup, it doesn't work...

You'll probably have to manually do your cards. Create a text box, type the text,
rotate, adjust to fit the space. Copy, paste, rotate 180 degrees and place in the
next space.

The setup in Publisher would be if you are using the front/back template, page setup
landscape, on the arrange menu
top - 0.5
side -1.0
grid guides 4 columns, 1 inch spacing.

 

[Mary Sauer]

Okay, I figured it out. You need two fields in your Excel database. Column A and
Column B. Merge column A into the first two columns in the previous posted setup,
rotate each, the first facing left... Merge column B into the third and fourth
column, the third column facing left...
This means separating your excel data into two columns.