How do I use an "IF" statement in Mailmerge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mia - 09 Nov 2005 20:09 GMT

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.

Reply to this Message

macropod - 09 Nov 2005 21:26 GMT

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

> 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.

Reply to this Message

Charles Kenyon - 09 Nov 2005 21:40 GMT

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

Signature

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.

> Hi Mia,
>
[quoted text clipped - 17 lines]
> been
>> unnable to do so.

Reply to this Message

macropod - 09 Nov 2005 21:48 GMT

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

Cheers

> Try
> {IF«AssetFeature»= "TRUE" "X" "FALSE"}
[quoted text clipped - 20 lines]
> > been
> >> unnable to do so.

Reply to this Message