View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mail Merge on 4up Postcard front/back

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 copypaste 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" wrote in message
...
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?
--
Print SpecialistAffinion Group


"Doug Robbins - Word MVP" wrote:

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" Jason wrote in message
...
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.)