Hello,

When I try and perform a mailmerge on a particular document, using a dataset, the finished document does not contain the field values, they are blank.  I am using the MergeField event.  I never used to have the code in place to cope with when e.FieldValue = null - I added it to stop the mailmerge falling over, but the FieldValue shouldn't be null (see attached dataset). When I do not use the MergeField event it appears to work ok.  Any assistance would be very much appreciated.

Thank you in advance.

My code is as follows:

Document doc = new Document(@"F:\temp\RPF25_Fragment.xml");

new Aspose.Words.Reporting.MergeFieldEventHandler(ProcessField);

DataSet ds = new DataSet("CJ");

@"F:\temp\DataSet.xml");

string[] fieldNames = doc.MailMerge.GetFieldNames();

foreach (DataTable dt in ds.Tables)

bool bRegion = false;

bool bProcess = false;

for (int i = 0; i < fieldNames.Length; i++)

try

if (dt.Columns.Contains(fieldNames[i]))

bProcess = true;

if (fieldNames[i].Substring(0, 11) == "TableStart:")

string actFN = fieldNames[i + 1];

if (dt.Columns.Contains(actFN))

bRegion = true;

bProcess = true;

break;

catch (System.ArgumentOutOfRangeException ex)

// Do nothing

if (bProcess == true)

if (bRegion == true)

else

// Delete any leftover fields

doc.Save(@"F:\temp\1d82ca00-b7fc-4cea-aca1-16f935219ae5.doc");

Hi

Thanks for your request. This occurs because your DataSet contains two tables. One field is stored in firs table and two fields are stored in second one. When you execute mail merge you have the following code in the beginning of MergeField event handler:

if ((e.FieldValue == null) || (e.FieldValue.ToString().ToUpper() == "NULL"))

{

   e.Text = "";

   return;

}

And this code does not allow processing the second table (When you start processing of the second table the template document already does not contain any merge fields.). There is very simple solution – Try using the following code:

if ((e.FieldValue == null) || (e.FieldValue.ToString().ToUpper() == "NULL"))

{

   return;

}

Best regards.

Thank you very much - it was a simple fix!

Floyd