Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge on 4up Postcard front/back
I have a slightly different situation than previously posted. I have a
postcard, 4up, that has merge information on the back of each card. Is there a way to insure that the customers name on the front will be married to the appropirate information on the back without printing each individual card seperately? (ex. Back 4 will have Type10 merge fields for each card for differing member fee information for each customer.) |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge on 4up Postcard front/back
Where do you have the datasource? The answer to that question will dictate
how you go about arranging this. -- 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 "Jason G" Jason wrote in message ... I have a slightly different situation than previously posted. I have a postcard, 4up, that has merge information on the back of each card. Is there a way to insure that the customers name on the front will be married to the appropirate information on the back without printing each individual card seperately? (ex. Back 4 will have Type10 merge fields for each card for differing member fee information for each customer.) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge on 4up Postcard front/back
Well, the data comes to us in a file that is processed in Unix. Once
processed it is send to a database where it is retrieved by a print operator thorough Xerox's Print Select. The file, when you look at it, is comma delimited. So one row will have one customer with all of thier information side by side seperated by commas. Now that I think about it, I'm not sure that we can do this the way we planned. If the data has the customers information like this; name, address1, address2, address3, type 10a, type 10b; name, address1, address2, address3, type 10a, type 10b; etc.... Then there is no way to split the data front/back unless it is done one page at a time. Is there a way to create just one postcard with merge information on it, duplex it, and the set it to print in groups of 4 where the frames are linked front/back? -- Print SpecialistAffinion Group "Doug Robbins - Word MVP" wrote: Where do you have the datasource? The answer to that question will dictate how you go about arranging this. -- 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 "Jason G" Jason wrote in message ... I have a slightly different situation than previously posted. I have a postcard, 4up, that has merge information on the back of each card. Is there a way to insure that the customers name on the front will be married to the appropirate information on the back without printing each individual card seperately? (ex. Back 4 will have Type10 merge fields for each card for differing member fee information for each customer.) |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge on 4up Postcard front/back
To do what you want to do, you will need to open the comma delimited file in
Excel, then add a column of sequential numbers, and in the adjoining column enter the following formula (which in this case assumes that the sequential numbers are in column A =IF(MOD(A1,2)=1,A1+1,A1-1) When you copy that down, you will have the following two columns of numbers 1 2 2 1 3 4 4 3 5 6 6 5 7 8 8 7 etc. You need to use copypaste special values, to convert the formula to values, then sort by the second column and use the spreadsheet in that format to merge the second side. -- 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 "Jason G" wrote in message ... Well, the data comes to us in a file that is processed in Unix. Once processed it is send to a database where it is retrieved by a print operator thorough Xerox's Print Select. The file, when you look at it, is comma delimited. So one row will have one customer with all of thier information side by side seperated by commas. Now that I think about it, I'm not sure that we can do this the way we planned. If the data has the customers information like this; name, address1, address2, address3, type 10a, type 10b; name, address1, address2, address3, type 10a, type 10b; etc.... Then there is no way to split the data front/back unless it is done one page at a time. Is there a way to create just one postcard with merge information on it, duplex it, and the set it to print in groups of 4 where the frames are linked front/back? -- Print SpecialistAffinion Group "Doug Robbins - Word MVP" wrote: Where do you have the datasource? The answer to that question will dictate how you go about arranging this. -- 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 "Jason G" Jason wrote in message ... I have a slightly different situation than previously posted. I have a postcard, 4up, that has merge information on the back of each card. Is there a way to insure that the customers name on the front will be married to the appropirate information on the back without printing each individual card seperately? (ex. Back 4 will have Type10 merge fields for each card for differing member fee information for each customer.) |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge on 4up Postcard front/back
Thanks for your help. Due to deadlines we decided to go another route with
this. I appreciate the fast response to my query. Thanks again. -- Print SpecialistAffinion Group "Doug Robbins - Word MVP" wrote: To do what you want to do, you will need to open the comma delimited file in Excel, then add a column of sequential numbers, and in the adjoining column enter the following formula (which in this case assumes that the sequential numbers are in column A =IF(MOD(A1,2)=1,A1+1,A1-1) When you copy that down, you will have the following two columns of numbers 1 2 2 1 3 4 4 3 5 6 6 5 7 8 8 7 etc. You need to use copypaste special values, to convert the formula to values, then sort by the second column and use the spreadsheet in that format to merge the second side. -- 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 "Jason G" wrote in message ... Well, the data comes to us in a file that is processed in Unix. Once processed it is send to a database where it is retrieved by a print operator thorough Xerox's Print Select. The file, when you look at it, is comma delimited. So one row will have one customer with all of thier information side by side seperated by commas. Now that I think about it, I'm not sure that we can do this the way we planned. If the data has the customers information like this; name, address1, address2, address3, type 10a, type 10b; name, address1, address2, address3, type 10a, type 10b; etc.... Then there is no way to split the data front/back unless it is done one page at a time. Is there a way to create just one postcard with merge information on it, duplex it, and the set it to print in groups of 4 where the frames are linked front/back? -- Print SpecialistAffinion Group "Doug Robbins - Word MVP" wrote: Where do you have the datasource? The answer to that question will dictate how you go about arranging this. -- 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 "Jason G" Jason wrote in message ... I have a slightly different situation than previously posted. I have a postcard, 4up, that has merge information on the back of each card. Is there a way to insure that the customers name on the front will be married to the appropirate information on the back without printing each individual card seperately? (ex. Back 4 will have Type10 merge fields for each card for differing member fee information for each customer.) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a field to an Off 97 mail merge using Office Pro 2003 | Mailmerge | |||
Mail Merge Losing Data | Mailmerge | |||
Mail Merge - Parameter prompts twice... | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge |