If function for a Salutation

[wally buch]

I am trying to set up the following situtation. If a field (First Name) is empty, then I want a salutation in a merge field to say "Dear Sir". But if the field (First Name) is not empty, I want it to say "Dear" (First Name)

I have tried if empty clauses, but just cant get it to work.

[LaRetta]

"Dear " & Case ( IsEmpty ( FirstName ) ; "Sir" ; FirstName )

[wally buch]

That did it. I didnt think the case function could be used in this way. Thanks very much for solving my problem.

[LaRetta]

Uhm, but how do you know it's not a woman? :qwery:

Maybe it should be "Dear person to whom I am writing:" Ha ha ah!! ... and you are most welcome!

[wally buch]

I have it as Dear Sir or Madam:

the only issue now is getting a colon after the (First Name) field.

[LaRetta]

I almost put it in automatically ...

"Dear " & Case ( IsEmpty ( FirstName ) ; "Sir" ; FirstName ) & ":"

[wally buch]

That works great! You are a great resource.