Solution for german salutation "Anrede: Sehr geehrte/er Frau/Herr" through CRM formula field

Solution for german salutation "Anrede: Sehr geehrte/er Frau/Herr" through CRM formula field

formula for german salutation in "Sie" version:

  1. If(${Contacts.Salutation}=='',If(${Contacts.Mass Update Formula},'',''),If(${Contacts.Last Name}=='','',Concat(If(${Contacts.Salutation}=='Herr','Sehr geehrter ','Sehr geehrte '),If(${Contacts.Titel}=='',Concat(${Contacts.Salutation},' ',${Contacts.Last Name}),Concat(${Contacts.Salutation},' ',${Contacts.Titel},' ',${Contacts.Last Name})))))

formula for german salutation in "Du" version:

  1. If(${Contacts.Salutation}=='',If(${Contacts.Mass Update Formula},'',''),If(${Contacts.First Name}=='','',Concat(If(${Contacts.Salutation}=='Herr','Lieber ','Liebe '),${Contacts.First Name})))