Mail Merge on 4up Postcard front/back

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason G - 17 Jan 2006 17:09 GMT

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.)

Reply to this Message

Doug Robbins - Word MVP - 17 Jan 2006 18:46 GMT

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

Signature

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

>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
[quoted text clipped - 4 lines]
> seperately? (ex. Back 4 will have Type10 merge fields for each card for
> differing member fee information for each customer.)

Reply to this Message

Jason G - 18 Jan 2006 23:04 GMT

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?

Signature

Print Specialist<>Affinion Group

> Where do you have the datasource? The answer to that question will dictate
> how you go about arranging this.
[quoted text clipped - 7 lines]
> > seperately? (ex. Back 4 will have Type10 merge fields for each card for
> > differing member fee information for each customer.)

Reply to this Message

Doug Robbins - Word MVP - 19 Jan 2006 05:00 GMT

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.

Signature

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

> 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
[quoted text clipped - 27 lines]
>> > seperately? (ex. Back 4 will have Type10 merge fields for each card for
>> > differing member fee information for each customer.)

Reply to this Message

Jason G - 20 Jan 2006 19:29 GMT

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.

Signature

Print Specialist<>Affinion Group

> 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
[quoted text clipped - 51 lines]
> >> > seperately? (ex. Back 4 will have Type10 merge fields for each card for
> >> > differing member fee information for each customer.)

Reply to this Message