when field empty dont show in email subject

[megatronixs]

Hi all,

I use email automation that creates an email and uses data from various fields to fill in the email and the email subject.

I have a field that sometimes could be empty. Is it possible to have the title of the field not show up when empty?

This is the code that is part of the email for the subject:

oMail.Subject = "Missing documents for the client: " & Me.client_name & ", ID code: " & Me.ID_code & "

When there is nothing in the field "ID code" there there should be no "ID code:" in the email subject.

Greetings.

 

[spikepl]

oMail.Subject = "Missing documents for the client: " & Me.client_name & (", ID code: " + Me.ID_code)

 

[megatronixs]

Hi Spikepl,

BIG THANKS, that really worked out

Greetings.