Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge fields are one record off from Excel
I have a merged mail directory form, so that several rows (from Excel) for
one person generates one letter, with multiple fields repeating. After this merged field, there are two columns that are merged. The data is merged one row off from what the spreadsheet column value indicates. How do I get the correct row/column data to merge appropriately? -- CHY |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge fields are one record off from Excel
Hi Christi,
Without seeing your field coding, it's hard to say. However, you'll probably be able to resolve the issue if you base your field coding on the fields used in my Word 97-2007 Catalogue/Directory Mailmerge Tutorial, available at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [MVP - Microsoft Word] "ChristiY" wrote in message ... I have a merged mail directory form, so that several rows (from Excel) for one person generates one letter, with multiple fields repeating. After this merged field, there are two columns that are merged. The data is merged one row off from what the spreadsheet column value indicates. How do I get the correct row/column data to merge appropriately? -- CHY |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge fields are one record off from Excel
I read your tutorial and would like to try adding the dummy record to the
Excel speadsheet. I was unable to see the merge field coding in your example word document. Here is the example of the code I have created. { IF {MERGESEQ} = "1" Policy#:{MERGEFIELD "POLICY"} ""} {SET Insured1{MERGEFIELD POLICY}} {IF {Insured1} {Insured2}" Current Limits {MERGEFIELD "Amt1"\#$#,###,###\* MERGEFORMAT}/{MERGEFIELD "Amt2\#$#,###,###\* MERGEFORMAT} (Page Break is here) Policy#:{MERGEFIELD "POLICY"} {MERGEFIELD "AName"} {MERGEFIELD "ADesc"}''{MERGEFIELD "AName"} {MERGEFIELD "ADesc"}"}{SET Insured2 {MERGEFIELD "POLICY"}} The merge fields Amt1 and Amt2 are the ones that are off by one row when document is merged. The merge fields AName and ADesc are the fields that are repetative. Please help me with getting the codes correct to accomplish the goal of having correct amounts after the repetative data. Thank you very much! -- CHY "macropod" wrote: Hi Christi, Without seeing your field coding, it's hard to say. However, you'll probably be able to resolve the issue if you base your field coding on the fields used in my Word 97-2007 Catalogue/Directory Mailmerge Tutorial, available at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [MVP - Microsoft Word] "ChristiY" wrote in message ... I have a merged mail directory form, so that several rows (from Excel) for one person generates one letter, with multiple fields repeating. After this merged field, there are two columns that are merged. The data is merged one row off from what the spreadsheet column value indicates. How do I get the correct row/column data to merge appropriately? -- CHY |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge fields are one record off from Excel
Hi ChristiY,
You can see the fieldcodes in the tutorial by following the instructions under the heading 'Viewing The Fields'. It helps if you've got Word set to display fieldshading (Tools|Options|View|Field ShadingAlways). Alternatively, to toggle the field code display on/off (so you can see/hide all the field codes), press Alt-F9. FWIW, I think you can use a field construction like: {QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}"{IF{MERGEFIELD POLICY} {Key} "{IF{MERGESEQ} 1 "{QUOTE 12}"} Policy#: {MERGEFIELD POLICY}{SET Key {MERGEFIELD POLICY}}¶ {MERGEFIELD AName} {MERGEFIELD ADesc}¶ Current Limits: "}{MERGEFIELD Amt1 \# $,0}/{MERGEFIELD Amt2 \# $,0}¶ "} -- Cheers macropod [MVP - Microsoft Word] "ChristiY" wrote in message ... I read your tutorial and would like to try adding the dummy record to the Excel speadsheet. I was unable to see the merge field coding in your example word document. Here is the example of the code I have created. { IF {MERGESEQ} = "1" Policy#:{MERGEFIELD "POLICY"} ""} {SET Insured1{MERGEFIELD POLICY}} {IF {Insured1} {Insured2}" Current Limits {MERGEFIELD "Amt1"\#$#,###,###\* MERGEFORMAT}/{MERGEFIELD "Amt2\#$#,###,###\* MERGEFORMAT} (Page Break is here) Policy#:{MERGEFIELD "POLICY"} {MERGEFIELD "AName"} {MERGEFIELD "ADesc"}''{MERGEFIELD "AName"} {MERGEFIELD "ADesc"}"}{SET Insured2 {MERGEFIELD "POLICY"}} The merge fields Amt1 and Amt2 are the ones that are off by one row when document is merged. The merge fields AName and ADesc are the fields that are repetative. Please help me with getting the codes correct to accomplish the goal of having correct amounts after the repetative data. Thank you very much! -- CHY "macropod" wrote: Hi Christi, Without seeing your field coding, it's hard to say. However, you'll probably be able to resolve the issue if you base your field coding on the fields used in my Word 97-2007 Catalogue/Directory Mailmerge Tutorial, available at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [MVP - Microsoft Word] "ChristiY" wrote in message ... I have a merged mail directory form, so that several rows (from Excel) for one person generates one letter, with multiple fields repeating. After this merged field, there are two columns that are merged. The data is merged one row off from what the spreadsheet column value indicates. How do I get the correct row/column data to merge appropriately? -- CHY |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I mail merge multiple lines in Excel into one Word record? | Mailmerge | |||
Mail merge from Excel missing every 5th record | Mailmerge | |||
Merge with Excel with multiple Record | Mailmerge | |||
word+excel mail merge omits 1st numeric record | Mailmerge | |||
How to do merge with varying fields in each record? | Mailmerge |