I'm using the "Send Mail" function to notify my clients when a work order is generated. In the email message I'll have info from the work order fields such as:

Contact Name: <%input.Contact_Name%>

I have several fields and they don't always have data so in the email it would show "Contact Name: null".

Some of these fields are related lookup fields and such. I know how to pull related data by using something like "a = Contacts_List[ID == input.Contacts_List];" so no issues there.

What I would like to do is if the field is "null"  is to replace the word "null" with "n/a" in the email.

Can I use a statement like:

a = Contacts_List[ID == input.Contacts_List] (lookup on form)

 "if a.Contact_Name is not null then b=a.Contact_Name -  else b="n/a" ? 

If that works how do I enter the value of "b" into the email? Can you provide an example or other suggestions?

Much appreciated!

Arlan