Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-25-2017, 10:08 AM
ayupchap ayupchap is offline Mac OS X Office 2013
Novice
 
Join Date: Oct 2016
Posts: 6
ayupchap is on a distinguished road
Default Converting a 1 or 0 into TRUE or FALSE?

Hi all

SO I have a mailmeger import which lists a true or false as a 1 or 0, thats expected and toally fine but to make my output mail merge betetr is there a way to set a formula or another method to turn the 1 or 0 into the word TRUE or FALSE (1 = TRYE and 0 = FALSE)

Be great if its possible
Reply With Quote
  #2  
Old 04-25-2017, 02:45 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Sure, you can evaluate a field's content, but you haven't really given us much to go on. Basically, you'd use either an IF field or a Formula field. For example:
{IF{MERGEFIELD MyField}= 1 "Text for True result" "Text for False result"}
or:
{IF«MyField»= 1 "Text for True result" "Text for False result"}
for the conditional display of some text.

Alternatively, you might use:
{={MERGEFIELD MyField}*45+15}
or:
{=«MyField»*45+15}
to display 60 when 'MyField' = 1, 15 when 0.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the 'Insert Merge Field' dropdown. The spaces represented in the field construction are all required.

I suggest you also have a read of the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
http://www.msofficeforums.com/mail-m...ps-tricks.html

PS: I note that I've referred you to the Mailmerge Tips and Tricks 'Sticky' thread, and to other resources before: http://www.msofficeforums.com/mail-m...-its-even.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
True 4:3 background dimensions a_gunslinger PowerPoint 1 11-28-2016 08:22 PM
Can you do True or False equations in Excel? WisCowboy Excel 1 02-05-2016 04:53 PM
Task Indicator - All predecessors complete true/false, y/n jdove78 Project 2 10-10-2012 05:53 PM
Mail Merge Function not Noticing 'True' vs. 'False' Statement danellekent Mail Merge 1 04-27-2012 02:19 AM
Macro not staying true oluc Word VBA 4 11-21-2010 08:10 AM


All times are GMT -7. The time now is 08:03 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft