How to leave out blank fields in email signatures (NULL statement)

The challenge many companies face is that some employees don't have all the information entered (generally because it doesn't relate to them - for example, mobile numbers aren't assigned to all employees). 

In this case, when an employee sends an email and a mobile number isn't entered against their name (Fields), there is a blank line in the signature when an email is sent. 

That's why below are given a few string manipulation functions with a description and examples, which explain how to exclude a certain field if the information doesn't exist and essentially, stop the blank line from appearing.

NULL statement

This is the NULL statement:

{$$NULL(           )$$VALUE(                      )$$} 

Example #1 - Removes 'm: ((Mobile))' when ((Mobile)) field is empty:

{$$NULL(Mobile)$$VALUE(m: ((Mobile)))$$}

Example #2  - Removes 'm: ((Mobile))' and the line below when ((Mobile)) field is empty - Hit 'Enter' key:

{$$NULL(Mobile)$$VALUE(m: ((Mobile))

How to remove ((Mobile)) when employees have no mobile

Ann Appleseed has no mobile number and accordingly, her employee data contains the empty mobile field. 

Signatures menu > Open email signature:

Click Preview and select Ann Appleseed:

  • Cell is empty

Copy/paste (1st part of the statement):


Copy/Paste (2nd part of the statement):


{$$NULL(Mobile)$$VALUE(cell ((Mobile)))$$} 

This removed 'cell ((Mobile))' when ((Mobile)) field is empty.

Ignore that the syntax is shown in the built-in designer. Always use Preview to see how it looks.

Use Preview to validate OK.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.