Mail Merging 2 sided 4 up postcards with Excel data

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

[Mary Sauer]

I think this would be better asked in an Excel group.

There is a sample Excel worksheet here that Ron Cohen compiled, maybe it will
help.
http://msauer.mvps.org/more_graphics.htm

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"azsuns" <abi...@farmersagent.com> wrote in message
news:1146168517.5...@y43g2000cwc.googlegroups.com...

[Doug Robbins - Word MVP]

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" <abi...@farmersagent.com> wrote in message
news:1146168517.5...@y43g2000cwc.googlegroups.com...

[reformation2]

Hi Doug,

I need some paid consulting assistance, the email
d...@removethismvps.org seems to be intentionally inoperable.

Could you please email me at david @ reformation . com

[Ed Bennett]

reformation2 <da...@reformation.com> was very recently heard to utter:

> I need some paid consulting assistance, the email
> d...@removethismvps.org seems to be intentionally inoperable.

Did you try removing the obvious?

--
Ed Bennett - MVP Microsoft Publisher

[azsuns]

Doug,
Being a novice I guess what I am having problems with is using the
formula so it works on columns that contain text. What would the
formula be to rearrange my columns in the same format as the 1,2,3,4 to
2,1,4,3. Thanks for your help in advance.

[Doug Robbins - Word MVP]

You need to add a column of numbers 1, 2, 3, 4 etc. and then apply the
formula to those numbers to create another series of numbers 2, 1, 4, 3 etc.
Then you execute the merge to one side of the post cards. Then sort the
data source on the column containing 2, 1, 4, 3 etc so that the numbers in
that column are in the order 1, 2, 3, 4, then using that sorted file as the
data source, execute the merge to the second size of the post cards.

Note that you must convert the column containing the formula that produces
the 2, 1, 4, 3 to the actual values (Copy, Edit>Paste Special>Values).

--
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" <abi...@farmersagent.com> wrote in message

news:1146501243.9...@y43g2000cwc.googlegroups.com...

[azsuns]

Thank You!!! It worked like a charm, as usual I was making things a
1000X more difficult. Once again many thanks, you have saved me hours
of peeling and labeling headache.

Best Regards,
Amir