View original (French)

Remove empty space - mailing

lynx87 -  
m@rina Posted messages 27233 Registration date   Status Modérateur Last intervention   -
Hello,

In a Word mail merge, I would like to remove the empty space created when a field is empty.
Example:
"title" <SPACE>"contact or company"

Line 1 under Excel list:
"title"
Mr.

"contact or company"
Dupond

Mail merge result is OK: Mr.<SPACE>Dupond

Line 2:
"title"
(nothing)

"contact or company"
Coca SA

Mail merge result is incorrect: <SPACE> Coca SA

So I would like to remove that <SPACE>. How can I do this please?

Unless there is a way to not manually insert a space between each merge field, which would ensure that the result is always correct, regardless of whether a field is empty or not.

Thank you very much for your help.

1 réponse

Réponse 1 / 1
m@rina Posted messages 27233 Registration date   Status Modérateur Last intervention   11 543
 
Hello

You need to use the If... Then... Else... fields that you can access via the Rules button.

This should result in:
{IF {MERGEFIELD title} <> "" " " ""}

which means: if the field "title" is not empty, we will have a space, otherwise we will have nothing.
We can do the opposite as well.

m@rina

--
Can we read my responses in full????
2