Did you follow all of the information in my post to which your refer. You
must first merge one side of the cards with the data in its original 1, 2 ,
3, 4 order, then sort the Excel spread sheet on the column containing
(before you sort) 2, 1, 4, 3 so that after the sort, the numbers in that
columns are in the order 1, 2, 3, 4. Then with the data arranged in that
order, you execute the merge to the other side of the card.

You need to explain in more detail what problem you are encountering if that
does not help.

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

"azsuns" wrote in message
oups.com...
Hi,
I have been browsing and searching for help on this issue to no avail.
What I am trying to do is mail merge a 2 sided 4 up postcard with my
Excel data. On the front I have the Address Block which is no problem,
however when I try to import the matching customer data to the back of
the postcard it does not match up at all with the front. I have also 2
publisher files setup, 1 for the front of the postcard and 1 for the
back.

I know the Excel data has to be in this format for the mail merge to
work correctly using this formula posted by Doug Robbins
=IF(MOD(A2,2)=1,A2+1,A2-1):

Front Back
1 2
2 1
3 4
4 3

However being a novice I need to get the formula to rearrange the order
for 15 columns in Excel using the above example. This is a small
example of what I am looking for:

Antonio F. Address 1 Phoenix
Sandy W. Address 2 Mesa
Beatriz E. Address 3 Tucson
Bob M. Address 4 Yuma


Any help is greatly appreciated!!

Amir