Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-11-2019, 04:29 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge Suppression issue Windows 10 Mail Merge Suppression issue Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,138
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You could use a series of conditional fields e.g as follows. Use CTR+F9 for the bracket pairs and press the enter key where you see ¶

{ 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"}¶
"}
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Suppression issue Mail Merge Code Issue Andrewwill Mail Merge 6 01-06-2018 10:25 PM
Mail Merge Suppression issue 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft