Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 04-06-2017, 02:57 PM
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

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
 



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 04:46 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