Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 04-07-2017, 10:22 AM
robert3 robert3 is offline Multiple Mail Merge Switches Windows 7 64bit Multiple Mail Merge Switches Office 2010 64bit
Novice
Multiple Mail Merge Switches
 
Join Date: Apr 2017
Posts: 3
robert3 is on a distinguished road
Default

Paul, your suggestion worked! but, I had to change the logic slightly so that the before and after text did not populate when there was a null value in the cell.

here's what I ended up using.

{IF { MERGEFIELD Cash_Credit \*MERGEFORMAT} = "" "" "Before test {MERGEFIELD Cash_Credit\# $,0.00;;} after text."}

Much appreciation to you and this great forum!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Mail Merge Switches Using multiple IF statements on a mail merge ajh19742000 Mail Merge 1 11-01-2016 06:11 PM
Multiple Mail Merge Switches Multiple mail merge PKAYHORM Mail Merge 1 09-29-2013 07:45 PM
Multiple Mail Merge Switches Multiple Mail Merge? imogul Mail Merge 1 06-24-2011 07:20 PM
Mail merge switches Jan Collier Mail Merge 0 08-29-2010 06:06 AM
Help with switches: Word mail merge with Excel ks_ Mail Merge 0 12-09-2009 05:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:40 AM.


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