View original (French)

Mail merge - replace empty fields with other fields

cny -  
m@rina Posted messages 27782 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

  1.
    m@rina Posted messages 27782 Registration date   Status Moderator Last intervention   11 568
     
    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