Merging with the empty table

Aspose.Words Product Family
1

Hi,
I have googled around and discovered the following thread : http://www.aspose.com/community/forums/2/267850/problem-merging-with-empty-table/showthread.aspx
I am using Aspose.Words.dll version 11.10. I noticed that when we are performing merging with an empty dataset, the result will display the merge table structure in the words which are not good.
May i know whether there is an option not to display the table when it’s merged with the empty dataset ?
This issue is not happened using Aspose.Words version 5.1
Regards,
hadi teo

2

Hi,
I have attached 2 samples.

  1. Aspose11EmptyDataTable.zip -> in this attachment, you can see that the file “out.doc” is still displaying the structure of the table even though the data is empty.
  2. Aspose5EmptyDataTable.zip -> in this attachment, you can see that the file “out.doc” has empty pages.
    Regards,
    hadi teo
3

Hi Hadi,

Thanks for your inquiry. Please use the MailMerge.CleanupOptions property to remove unused merge fields during mail merge as shown in following code snippet. The MailMergeCleanupOptions enumeration specifies options that determine what items are removed during mail merge.

I suggest you to read following documentation link for your kind reference.
https://docs.aspose.com/words/net/clean-up-before-or-during-mail-merge/
https://docs.aspose.com/words/net/

// Use DataTable as a data source.
DataTable resultsTable = GetEmptyDataTable();
Document doc = new Document(MyDir + "in.doc");
doc.MailMerge.CleanupOptions |= Aspose.Words.Reporting.MailMergeCleanupOptions.RemoveEmptyParagraphs;
doc.MailMerge.CleanupOptions |= Aspose.Words.Reporting.MailMergeCleanupOptions.RemoveUnusedRegions;
doc.MailMerge.CleanupOptions |= Aspose.Words.Reporting.MailMergeCleanupOptions.RemoveUnusedFields;
doc.MailMerge.CleanupOptions |= Aspose.Words.Reporting.MailMergeCleanupOptions.RemoveContainingFields;
doc.MailMerge.ExecuteWithRegions(resultsTable);
doc.Save(MyDir + "out.doc");
4

Hi Tahir,
Thanks for your assistance. Your suggestion is very helpful. My issue has been resolved.
Regards,
hadi teo

5

Hi Hadi,

Thanks for your feedback. Please feel free to ask if you have any question about Aspose.Words, we will be happy to help you.