MailMerge - removing empty row

[Dobracik1]

Hi all,




I'm completely newbie in word mailmerge and Word VBA.
I have an excel file, where I have 1 column linked to Word via mailmerge where output of it is a template of agreement for employees. In that column I have complex formula which concatenated multiple articles where is a change for employee.

If there s no change is shows me "". As each article should have his own row in word, when there is no changes in article it gives me automatically empty row

Is there any option to remove that or setup it in mail merge, only? Find and replace in this case does not work, as this is removing me empty rows from the whole template, which I actually need but not from mailmerge.
Attaching the empty sample with my specific mailmerge.



Thanks,
Andy

[macropod]

See Mailmerge Empty Line Suppression in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum (https://www.msofficeforums.com/mail-...ps-tricks.html).

There is only one mergefield in your document.