ShowTable of Contents
This example demonstrates how to create lookups which will automatically add a new line ONLY if there is information returned from another lookup.
For Example, in the configuration below, if the Fax number is not set in the users Person document, a empty line if left in the signature.
Resulting signature
To overcome this, new lookups can be created to automatically insert a new line only if the phone/fax/mobile lookup returns data.
New Lookups
The following steps describe how to create the new lookups.
1. Create a new lookup called (!NewLineFormula!)
This lookup returns a new line in the correct format for the type of email, e.g. Rich Text, HTML or Plain text
This link shows how to create the (!NewLineFormula!) lookup (
How to add Carriage Returns into a formula)
2. Create new lookups for Phone, Fax and Mobile.
These formula lookups reply on the default (!Phone!), (!Mobile!) and (!Fax!) lookups which are part of the default installation.
Phone
strPhone:='(!Phone!)';@If(strPhone='';'';(!NewLineFormula!) + 'Phone:'+strPhone)
Fax
strFax:='(!Fax!)';@If(strFax='';'';(!NewLineFormula!) + 'Fax:'+strFax)
Mobile
strMobile:='(!Mobile!)';@If(strMobile='';'';(!NewLineFormula!) + 'Mobile:'+strMobile)
New Signature Configuration
The new lookups can now be used in a signature configuration document.
Resulting signature when the fax number is missing.
