Mail Merge not supressing blank lines

Aspose.Words Product Family
1

Hello,
We are evaluating Aspose.Words .Net for automation of Mail Merge. Everything is working well except, blank address lines are not being suppressed as expected.
For instance, if the second line of an address is empty, Aspose.Words should suppress the line during the merge but it is producing a blank line instead. The DoNotSupressBlankLines setting is False and we are merging using the two arrays as the datasource. The problem occurs whether or not the fieldvalue is Null or an Empty string.
We are running .Net 4.0 but using the client profile based dll version 11.3.0.0.
Also, Microsoft Word 2010 is correctly supressing the blank address line when we merge from a CSV file.
Please help us to resolve because this is a key feature we require to work.
Thanks in advance,
Bob Baldwin of Trabon Solutions
aka vsdotnetguy

2

Hi Bob,
Thanks for your inquiry. You can use MailMerge.DeleteFields method to remove non-merged fields from document. See the following link for more information. Hopefully it would fulfill your requirments
https://docs.aspose.com/words/net/clean-up-before-or-during-mail-merge/
Please feel free to contact us for any further assitacne.
Best Regards,

3

Hi Tilal,
We will try and use the RemoveEmptyParagraphs option but do not understand why Aspose.Words is ignoring this MailMergeSetting that Word clearly is applying during mail merge operations.
Please request the product manager to consider fully supporting the MailMergeSettings.DoNotSupressBlankLines property as it currently seems to be useless.
Hopefully, the RemoveEmptyParagraphs option will have the desired effect.
We will let you know how it goes.
Thanks…Bob Baldwin
Trabon Solutions
aka VSDotNetGuy

4

Hi Bob,
Please accept my apology for the delayed response. Sure, we will discuss MailMergeSetting.DoNotSurpressBlankLines property functionality with our development team and its implementation in Aspose.Words accordingly. We will update you via this thread ASAP.
Sorry for any inconvenience faced.
Best Regards,

5

Hello Tilal,
The RemoveEmptyParagraphs CleanupOption worked well for our needs.
Thx…Bob Baldwin
Trabon Solutions
aka VSDotNetGuy