Merging data on both side of a sheet

T

TroyN

I print reminder postcards 4-up on 8.5 x 11" sheet. (I am using the postcard
page layout.) I need to be able to use the same data base and print one side
with the client's name, address, etc. Then run the cards through a second
time and print the back of the card with reminder information. When I do so,
Mrs. Smith's reminder information will end up on the back of Mrs. Jones' card
because I have no way of controlling the order of the cards. Is there any
way to accomplish this?
Thanks!!
 
M

Mary Sauer

You need to setup your data differently. Maybe two data bases. There are
formulas for this in Excel.

Front Back
Mr. Smith Mr. Jones
Mr. Jones Mr. Smith
Jane Betty
Betty Jane

Whatever is on the right on the front will be on the left on the back.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set up and printing a 4-up mail merged postcard 0
Print order of TriFold - Publisher 365 0
creating two cards on one A4 page 3
Creating a Chart on form from selected data in query. 0
Postcard Duplex Printing with Mail Merge 2
How to print 4 page design on 4.5" x 5.5" top fold cards 1
2- side Postcard printing with merged addresses 1
To set up and print two pages on one 8.5 x 11 landscape sheet? 2

Top