Many of our new accounts get set up on the web, and get entered as "John Smith" rather than "Mr. John Smith".
We would like the "Dear" salutation to default to "John" if there is no title, but "Mr. Smith" if there is a title. I've studied up on the documentation for TR_SALUTATION_FORMAT, but haven't found a way to do this. Am I missing something, or has someone come up with a way to make this happen?
I just uploaded code that will allow you to insert specific salutations for all accounts built online (or within a date range or in a particular list, depending on how you edit the code) to my profile: http://www.tessituranetwork.com/Community/members/luciespieler8144/files/default.aspx
It’s called INSERT_TX_CUST_SAL.sql
This should be edited by someone who understands your database, and tested on your test system first, as it does add data to your database.
Lucie
______________________________Lucie SpielerIT Development and Training Manager
Florida Grand Opera