Hello Tessitura world!
I'm trying to work on our triggered emails (WordFly) and running into an issue with personalization. If the constituent is a household, the list pulls their first and last names into the "CUSTOMER_LNAME" column, whereas if the constituent is an individual they put the first name in "CUSTOMER_FNAME" and the last name in the "CUSTOMER_LNAME" column. Does anyone know how to reliably have the correct names in the correct columns? I'm only willing to have *so many* emails addressed to "Friend", ya know?
Similarly, is there a way to have the word "Household" come off the record? It autopopulates on the constituent record and it's annoying to clear off when creating print campaigns.
Thank you all!
Corinne
Hi Corinne,
Have you tried pulling the lsal_desc field from FT_GET_PRIMARY_SALUTATION()? It depends you you use the letter salutation over there. I think that's the intent of lsal_desc (thought admittedly we have a few "Sir/Madam"s)
select lsal_desc from FT_GET_PRIMARY_SALUTATION()where customer_no = 142568
Returns ...
Heath