'If... then... else' - output dependent on multiple fields

[SiBrad]

Hello, I'm very new to mail merge and need some help.



I am creating a letter template using mail merge which refers to the reader's child or children. Using the 'If... then... else' function I've managed to set it up so it uses the term 'child' if the field 'No of Children' = 1 and 'children' if the value in that field is greater than 1. Simple!

However, pronouns are a difficulty. I am able to set it up to refer to children as 'they' if the 'No of Children' value is greater than 1. However, when the value is equal to 1, I need it to then check the 'Gender of Child' field to determine whether to use the pronoun 'He' or 'She'. In short, I want it to check the value of one field and then, if the value of that field =1, to check the value of another field. Is there a way to do this?

Thank you!

[SiBrad]

Me again!

I want to make an "If... then... else..." field that compares two fields from my data source. Basically, I want the field to express "if 'X' does not equal 'Y', print 'X'" where X and Y are two text fields in my database. As it is, I can express 'if 'X' does not equal [fixed value] then...' but it doesn't seem to allow me to compare it to another field.

Any ideas?

[macropod]

Hi SiBrad,

For the first issue, encode the field as:
{IF{MERGEFIELD No_of_Children} > 1 "they" "{IF{MERGEFIELD Gender_of_Child}= "F" "she" "he"}}
or:
{IF«No_of_Children» > 1 "they" "{IF«Gender_of_Child»= "F" "she" "he"}}

For the secondfirst issue, encode the field as:
{IF{MERGEFIELD X} = {MERGEFIELD Y} "text for equal" "text for NOT equal"}
or:
{IF«X» = «Y» "text for equal" "text for NOT equal"}

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.

[SiBrad]

It works! Amazing, thank you.