Hi,
My scenario is similar to Mail Merge not supressing blank lines. However, solution specified in the link does not work for me.
Below is my sample code
// Creating datasource
var dt = new DataTable(“Table1”);
ds.Tables.Add(dt);
dt.Columns.Add(“LEGAL_NAME”, typeof(string));
dt.Columns.Add(“PO_BOX”, typeof(string));
dt.Columns.Add(“PO_LOCALITY”, typeof(string));
dt.Columns.Add(“PO_POSTCODE”, typeof(string));
dt.Columns.Add(“M_BUILDING”, typeof(string));
dt.Columns.Add(“M_SHOP_NO”, typeof(string));
dt.Columns.Add(“M_STREET_NO”, typeof(string));
dt.Columns.Add(“M_STREET”, typeof(string));
dt.Columns.Add(“M_LOCALITY”, typeof(string));
dt.Columns.Add(“M_STATE”, typeof(string));
dt.Columns.Add(“M_POSTCODE”, typeof(string));
dt.Rows.Add(“SAM SAMPLE”, null, null, null, “23”, “Bldg1”, “23”, “Elizabeth”, “Sydney”, “NSW”, “2000”);
dt.Rows.Add(“SAM SAMPLE”, “PO BOX 1243”, “MINTO”, “2533”, null, null, null, null, null, null, null);
// Merging doc
doc.MailMerge.RemoveEmptyParagraphs = true;
doc.MailMerge.RemoveEmptyRegions = true;
doc.MailMergeSettings.DoNotSupressBlankLines = false;
doc.MailMerge.Execute(dt);
doc.Save(outputStream, SaveFormat.Pdf);
I am using Aspose.Words assembly with version 2011.09.30 in .net 4.5 environment.MergeTest.zip (29.9 KB)
Thanks,
Yash