I've got an Excel spreadsheet for Asset management with columns for different
features, with "TRUE" or "FALSE" values. I'd likke to print an "X" in a form
letter during a mailmerge is a certain column contains "TRUE", but have been
unnable to do so.

Hi Mia,

If you select your existing mailmerge field, which probably looks something
like:
«AssetFeature»
and Press Ctrl-F9, you'll get:
{ «AssetFeature» }
If you then fill in between the braces so that you've got:
{IF«AssetFeature»= "TRUE" X "FALSE"}
that should give the result you're after.

Cheers

"Mia" wrote in message
...
I've got an Excel spreadsheet for Asset management with columns for
different
features, with "TRUE" or "FALSE" values. I'd likke to print an "X" in a
form
letter during a mailmerge is a certain column contains "TRUE", but have
been
unnable to do so.

Try
{IF«AssetFeature»= "TRUE" "X" "FALSE"}

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"macropod" wrote in message
...
Hi Mia,

If you select your existing mailmerge field, which probably looks
something
like:
«AssetFeature»
and Press Ctrl-F9, you'll get:
{ «AssetFeature» }
If you then fill in between the braces so that you've got:
{IF«AssetFeature»= "TRUE" X "FALSE"}
that should give the result you're after.

Cheers

"Mia" wrote in message
...
I've got an Excel spreadsheet for Asset management with columns for
different
features, with "TRUE" or "FALSE" values. I'd likke to print an "X" in a
form
letter during a mailmerge is a certain column contains "TRUE", but have
been
unnable to do so.

Or:
{IF«AssetFeature»= TRUE X FALSE}
You don't need the quotes unless the strings have spaces in them ...

Cheers



"Charles Kenyon" wrote in
message ...
Try
{IF«AssetFeature»= "TRUE" "X" "FALSE"}

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"macropod" wrote in message
...
Hi Mia,

If you select your existing mailmerge field, which probably looks
something
like:
«AssetFeature»
and Press Ctrl-F9, you'll get:
{ «AssetFeature» }
If you then fill in between the braces so that you've got:
{IF«AssetFeature»= "TRUE" X "FALSE"}
that should give the result you're after.

Cheers

"Mia" wrote in message
...
I've got an Excel spreadsheet for Asset management with columns for
different
features, with "TRUE" or "FALSE" values. I'd likke to print an "X" in a
form
letter during a mailmerge is a certain column contains "TRUE", but have
been
unnable to do so.