Hello,
I can't figure out how to have multiple logical tests in an IF Expression. I have a typical database with names and addresses. In the [Firstname] data field there are some full names and some initials. If there is a name, we want the merged letter to say, Dear Whateverthenameis, if there is an initial, we want the merged letter to say, Dear Friend,.

I have written the expression:
IF([Firstname]="A","Friend,", [Firstname]) and it works fine but I can't figure out how to include the initials, B, C, D,...Z.

I have tried adding another expression at the end, replacing the initial A with B, etc. I get errors like, "End of expression expected" or "Logical Expected". I can find nothing to explain the proper syntax or any clue to what I am leaving out.

Thanks if you can help.
Jim