[DonnaRae]

The second option that you gave is what I need, but I don't understand it.
{ SET cspi "N -- What does that mean?

Donna

"Peter Jamieson" wrote:

It depends.

First, it's generally easier to see what's going on if you use alt-F9 to
toggle between "field display" and "field results display", and use ctrl-F9
to insert each pair of the special field code braces {}.

If state = MA
then "mass distributor contact info for MA"
else "company salesperson info for MA"

then I suggest you use something like

{ IF "{ MERGEFIELD state }" = "MA"
"mass distributor contact info for MA"
"company salesperson info for MA"
}{ IF "{ MERGEFIELD state }" = "NY"
"mass distributor contact info for NY"
"company salesperson info for NY"
}

and so on for each state.

If what you need is

If state = MA
then "mass distributor contact info for MA"
else if state = "NY"
then "mass distributor contact info for NY"
etc. and if state isn't any of those 20 states , then
"company salesperson info"

then you could try something like

{ SET cspi "N"
}{ IF "{ MERGEFIELD state }" = "MA"
"mass distributor contact info for MA"
"{ SET cspi "Y" }"
}{ IF "{ MERGEFIELD state }" = "NY"
"mass distributor contact info for NY"
"{ SET cspi "Y" }"
}{ IF cspi = "N"
""
"company salesperson info" }

Each pair of () needs to be the field code braces you can isert using
ctrl-F9.

I have a feeling I haven't quite got that right but have a go and see what
happens.

Peter Jamieson


"DonnaRae" wrote in message
...
{IF {MERGEFIELD State} = "MA" "mass distributor contact info" "company
salesperson info"}

How do I add more "ifs" to this? I need to add about 20 states, and the
alternate text is always "company salesperson info". Does that have to go
at
the end of each "if", or will it work if it is placed just at the end of
all
the "ifs"?

Thanks,

Donna