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.