A
azsuns
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 2003 data. On the front of Publisher 2003I 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):
Column 1 Column 2
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
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 2003 data. On the front of Publisher 2003I 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):
Column 1 Column 2
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