Mail Merging 2 sided 4 up postcards with Excel data

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

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
 
R

reformation2

Hi Doug,

I need some paid consulting assistance, the email
(e-mail address removed) seems to be intentionally inoperable.

Could you please email me at david @ reformation . com
 
E

Ed Bennett

reformation2 said:
I need some paid consulting assistance, the email
(e-mail address removed) seems to be intentionally inoperable.

Did you try removing the obvious?
 
A

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

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top