Skip to main content
I am creating an email template, and basically want it to be able to read as follows:

 

"Dear {!Contact.FirstName} and {!Contact.Partner_Name__c};

 

You are invited ... "

 

Naturally, I don't want the "and" between the Contact's name and the Partner's name to be visible when the Partner name field is blank. And, I would want the ";" to appear straight after the Contact's name.

 

Is this possible?

 

Thanks,

 

Jackie
11 个回答
  1. 2015年11月5日 05:20

    One more try :

    Dear {!if(ISBLANK(Contact.Partner_Name__c),Contact.FirstName,Contact.FirstName & "and" & Contact.Partner_Name__c)};

     

    If abpve doesnt work,Could you try one more thing?

     

    How about creating formula field which returns a text using the above formula simple and use this in merge field:

    if(ISBLANK(Contact.Partner_Name__c),Contact.FirstName,Contact.FirstName & "and" & Contact.Partner_Name__c)

     

     
0/9000