Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.publisher,microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merging 2 sided 4 up postcards with Excel data
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link Excel to Word Mail Merge - found problem for mix data type | Mailmerge | |||
Why can't I see the excel data in the Word mail merge for labels | Mailmerge | |||
ADDRESS NUMBERS SHOW AS 0 WHEN MAIL MERGING FROM EXCEL | Mailmerge | |||
Carrying Excel cell properties into word when mail merging | Mailmerge | |||
Format Excel data for merging in Word | Mailmerge |