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 |
#2
Posted to microsoft.public.publisher,microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merging 2 sided 4 up postcards with Excel data
Hi Doug,
I need some paid consulting assistance, the email seems to be intentionally inoperable. Could you please email me at david @ reformation . com |
#3
Posted to microsoft.public.publisher,microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merging 2 sided 4 up postcards with Excel data
reformation2 was very recently heard to utter:
I need some paid consulting assistance, the email seems to be intentionally inoperable. Did you try removing the obvious? -- Ed Bennett - MVP Microsoft Publisher |
#4
Posted to microsoft.public.publisher,microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merging 2 sided 4 up postcards with Excel data
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. |
#5
Posted to microsoft.public.publisher,microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merging 2 sided 4 up postcards with Excel data
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, EditPaste SpecialValues). -- 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... 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. |
#6
Posted to microsoft.public.publisher,microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merging 2 sided 4 up postcards with Excel data
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 |
Reply |
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 |