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

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:
https://www.msofficeforums.com/mail-...ps-tricks.html

PS: I note that I've referred you to the Mailmerge Tips and Tricks 'Sticky' thread, and to other resources before: https://www.msofficeforums.com/mail-...-its-even.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]