View original (French)

Mail merge - replace empty fields with other fields

cny -  
m@rina Posted messages 27378 Registration date   Status Moderator Last intervention   -
Hello,

Is it possible to replace an empty field with another field during a mail merge? If yes, how?

For example, if the "personal address" field is empty, replace it with the "work address" field.

Thank you.

Configuration: Windows / Chrome 56.0.2924.87

1 answer

Answer 1 / 1
m@rina Posted messages 27378 Registration date   Status Moderator Last intervention   11 561
 
Good evening,

You need to use an IF field:

{ IF { MERGEFIELD personal address } = "" "{ MERGEFIELD work address }" "{ MERGEFIELD personal address}" }

<bold>ALL </bold>the { } are created with Ctrl+F9.

m@rina

Beware of the herbal tea: it's a dangerous poison...
1