Thread: [Solved] Multiple Mail Merge Switches
View Single Post
 
Old 04-06-2017, 02:57 PM
robert3 robert3 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Apr 2017
Posts: 3
robert3 is on a distinguished road
Default

Great recommendation, Paul! Thanks for the fast reply.

The IF works! it populates the before and after text, including the Cash_Credit value. However, having one small issue now. When the source value contains no data (null; empty cells in Excel) the Comparison Operator <> doesn't identify this, but still populates the before and after text.

i.e. You were selected to receive a cash credit of which will be mailed to the address we have on file.

Also, here are a few things that I've tried, but didnt work:
>= 1
!= 0



Any additional help will be greatly appreciated.
Reply With Quote