Mail Merge on 4up Postcard front/back

[Jason G]

I have a slightly different situation than previously posted. I have a
postcard, 4up, that has merge information on the back of each card. Is there
a way to insure that the customers name on the front will be married to the
appropirate information on the back without printing each individual card
seperately? (ex. Back 4 will have Type10 merge fields for each card for
differing member fee information for each customer.)

 

[Doug Robbins - Word MVP]

Where do you have the datasource? The answer to that question will dictate
how you go about arranging this.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Jason G]

Well, the data comes to us in a file that is processed in Unix. Once
processed it is send to a database where it is retrieved by a print operator
thorough Xerox's Print Select. The file, when you look at it, is comma
delimited. So one row will have one customer with all of thier information
side by side seperated by commas. Now that I think about it, I'm not sure
that we can do this the way we planned. If the data has the customers
information like this; name, address1, address2, address3, type 10a, type
10b; name, address1, address2, address3, type 10a, type 10b; etc....

Then there is no way to split the data front/back unless it is done one page
at a time. Is there a way to create just one postcard with merge information
on it, duplex it, and the set it to print in groups of 4 where the frames are
linked front/back?

 

[Doug Robbins - Word MVP]

To do what you want to do, you will need to open the comma delimited file in
Excel, then add a column of sequential numbers, and in the adjoining column
enter the following formula (which in this case assumes that the sequential
numbers are in column A

=IF(MOD(A1,2)=1,A1+1,A1-1)

When you copy that down, you will have the following two columns of numbers

1 2
2 1
3 4
4 3
5 6
6 5
7 8
8 7

etc.

You need to use copy>paste special values, to convert the formula to values,
then sort by the second column and use the spreadsheet in that format to
merge the second side.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Jason G]

Thanks for your help. Due to deadlines we decided to go another route with
this. I appreciate the fast response to my query.

Thanks again.