![]() |
|
#4
|
||||
|
||||
|
You insert all of it where you want the result to appear. It will show those fields and their leading texts where the values are greater than 0
{ IF { MERGEFIELD "Field Name 1"} > 0 "Field Name 1: { MERGEFIELD "Field Name 1" \# "£,0"} "}{ IF { MERGEFIELD "Field Name 2"} > 0 "Field Name 2: { MERGEFIELD "Field Name 2" \# "£,0"} "}{ IF { MERGEFIELD "Field Name 3"} > 0 "Field Name 3: { MERGEFIELD "Field Name 3" \# "£,0"} "} You can use Import and export field constructions as text if you wish to convert the text above to fields (change the text as appropriate)
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Code Issue
|
Andrewwill | Mail Merge | 6 | 01-06-2018 10:25 PM |
Mail merge repeating decimals issue
|
jmorris33 | Mail Merge | 2 | 01-10-2015 11:54 PM |
| Mail Merge Formatting Issue with Conditional IFs | robbeh | Mail Merge | 5 | 07-08-2014 07:39 AM |
| time field issue in mail merge | Aude | Mail Merge | 16 | 05-18-2014 06:22 AM |
| Word 2007 mail merge issue | steelervince | Mail Merge | 0 | 02-17-2010 02:26 PM |