Hi Kelly,
Sorry this is so late to the game, but you could ultimately use an email script to choose which field to send. In the velocity script, you could have a formula similar to what you are imagining that would use the first name only if it did not equal a certain value. If it did, then you can use another field.
Best,
Erik
The solution we use to get around this problem is a simple velocity email script token.
Essentially, this token looks at the value of the lead's first name, and if it's a default/blank value, we change the greeting to something generic, otherwise greet them by name.
Looks kind of like this:
#if (${lead.FirstName} == "")
Greetings from MyCompany!
#else
Hi ${lead.FirstName},
#end
Inside the email, you simply put the my.token for your email script in place of whatever salutation you had prior.
Another option, if you're not averse to adding fields to your instance, is to go with a Formula Field that evaluates the lead's first name.
Hope this helps!
This is great, Scott but I'm still having some trouble. If the first name field is empty, I don't want to have any greeting there at all. Any thoughts? Thanks in advance!
HI Robin,
With the Velocity scripting language, you can create the whole block of words and create a sophisticated logic with multiple if's or cases.
-Greg
#if( !$lead.FirstName.isEmpty() )
Hello ${lead.FirstName}.
#end
(But really you should open a new thread instead of resuscitating an old one, since otherwise it'll never have a Correct answer.)
And opening new threads also guarantees that many more people will see it, notice it and will be likely to provide an answer.
-Greg