Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2020, 10:26 AM
shaggy30005 shaggy30005 is offline Is there a way to use dashes in IF statement merges Windows 10 Is there a way to use dashes in IF statement merges Office 2016
Novice
Is there a way to use dashes in IF statement merges
 
Join Date: Jul 2020
Posts: 1
shaggy30005 is on a distinguished road
Default Is there a way to use dashes in IF statement merges

I'm trying to make some conditional merges based on text that contains a dash. This is what my coding looks like:



{IF { «F12» } = “Client - DNWTP” “This letter confirms that in accordance with your instructions, ABC Group will no longer be representing you in connection with your «F11» claim.” “”}

With some testing I know that it doesn't like the - however I can't believe I am the first to run across this issue. Is there a work around for this that does not involved updating our entire document management system to remove dashes?

Thanks,

Last edited by shaggy30005; 07-14-2020 at 01:38 PM.
Reply With Quote
  #2  
Old 07-14-2020, 10:29 PM
gmayor's Avatar
gmayor gmayor is offline Is there a way to use dashes in IF statement merges Windows 10 Is there a way to use dashes in IF statement merges Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
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 of
Default

Your syntax as printed is a tad awry, but if you use


{IF { MERGEFIELD F12 } = "Client - DNWTP" "This letter confirms that in accordance with your instructions, ABC Group will no longer be representing you in connection with your { MERGEFIELD F11 } claim." "" }


and the Field F12 contains "Client - DNWTP" then the code works as intended
__________________
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting a Select statement in Excel to an update statement shabbaranks Excel Programming 5 10-31-2018 11:47 PM
Is there a way to use dashes in IF statement merges Add dashes to each line of a list Tomperm Word 2 02-15-2017 05:48 PM
Is there a way to use dashes in IF statement merges changing colons into dashes retrofan Word 2 07-27-2014 05:05 AM
Track mail merges bro4dhead Outlook 0 04-11-2013 02:44 AM
letters are dashes pmd Word 5 03-05-2012 08:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:29 AM.


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