Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-09-2014, 05:17 PM
oakye oakye is offline Max length of TrueText in IF Statement? Mac OS X Max length of TrueText in IF Statement? Office for Mac 2011
Novice
Max length of TrueText in IF Statement?
 
Join Date: Apr 2014
Posts: 3
oakye is on a distinguished road
Default

Very helpful - thanks for confirming, macropod!



I have been able to test this successfully. I realized that if I copy & paste text from elsewhere in my .DOC, into the field code, it doesn't always show up. (This happens even if I choose to update fields, and save the file.) I am successful when I manually type in the text of War & Peace haha.

Other:
- I used 2 single quotes together, vs a double quote, in the TRUE/FALSE statements. Somewhere on the interwebs I read that this makes sure that Word understands the text in between the quote marks. I see you didn't do that...so I will attempt that myself, too.

New Twist:
-Within the TRUE/FALSE text, can I also add a hyperlink? I don't even need it to mask the URL. I have not been able to save a copy of the merged file in PDF format.

Example:
In the TRUE text of an IF statement:

{IF { MERGEFIELD Salesforce.Custom_Field__c } = "" "Lorem commodo magna eros quis urna.¶
Nunc viverra insert imperdiet enim. Fusce est. ‘‘Vivamus a tellus’’.¶
Pellentesque then click this link here { HYPERLINK "http://www.cnn.com" }."}
Reply With Quote
  #2  
Old 04-09-2014, 05:52 PM
macropod's Avatar
macropod macropod is offline Max length of TrueText in IF Statement? Windows 7 32bit Max length of TrueText in IF Statement? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by oakye View Post
Somewhere on the interwebs I read that this makes sure that Word understands the text in between the quote marks. I see you didn't do that.
Actually, that's exactly what I did - they're pairs of single quotes, not double quotes. There are ways of using double quotes (e.g. inside a QUOTE field and prefixed by a \ character), but that's no less complicated than using paired single quotes.
Quote:
Within the TRUE/FALSE text, can I also add a hyperlink? I don't even need it to mask the URL. I have not been able to save a copy of the merged file in PDF format.
Yes, but it won't come out as an active hyperlink - just plain text.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-10-2014, 02:48 PM
oakye oakye is offline Max length of TrueText in IF Statement? Mac OS X Max length of TrueText in IF Statement? Office for Mac 2011
Novice
Max length of TrueText in IF Statement?
 
Join Date: Apr 2014
Posts: 3
oakye is on a distinguished road
Default

Thanks for the quick confirmation!!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Movie Length helmerg PowerPoint 0 07-29-2013 12:23 PM
Critical Path Length ketanco Project 5 03-15-2013 01:12 PM
Max length of TrueText in IF Statement? Searching by Quotation Length cheech1981 Word 4 03-14-2013 08:23 AM
page length mzimpfer Word 2 10-23-2010 11:53 AM
How to set the same length for different lines myword29 Word 0 09-28-2007 08:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:50 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