Hi there,
Thank you for this additonal information. What you're asking sounds very complex, I suppose the implementation would be something such as below, although it doesn't seem to make sense if you have more than one separate region on your template.
// Used to name the output documents.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
int recordIndex = 0;
// Your dataset with all data and relations populated
DataSet dataSet = GetData();
// Define where to save the merged document output to
string path = dataDir + @"\Output Documents\" + "Merged Document {0}.doc";
// Create a temporary dataset containing only the rows we want to merge for one document
DataSet tempDataSet = dataSet.Clone();
foreach (DataTable table in dataset.Tables)
{
// Encountered a regular datatable with no child tables and is not the child of another table
if (table.ChildRelations.Count == 0 && table.ParentRelations.Count == 0)
{
foreach(DataRow row in table.Rows)
{
// Import this row into the temporary datatable in the dataset
DataTable tempTable = tempDataSet.Tables[table.TableName];
tempTable.ImportRow(row);
GenerateDocument(doc, tempDataSet, string.Format(path, recordIndex));
tempTable.Rows.RemoveAt(0);
recordIndex++;
}
}
else
{
// Encountered a datatable with child tables, iterate through all of the relations, merge those rows and save them to separate documents.
foreach (DataRelation relation in table.ChildRelations)
{
foreach (DataRow parentRow in table.Rows)
{
// Import this row into the temporary datatable in the dataset
DataTable parentTable = tempDataSet.Tables[parentRow.Table.TableName];
tempDataSet.Tables[parentRow.Table.TableName].ImportRow(parentRow);
foreach (DataRow childRow in parentRow.GetChildRows(relation))
{
// Import this row into the temporary datatable in the dataset
DataTable childTable = tempDataSet.Tables[childRow.Table.TableName];
childTable.ImportRow(childRow);
// Merge and save document
GenerateDocument(doc, tempDataSet, string.Format(path, recordIndex));
recordIndex++;
// Remove this row to make the table empty for the next merge
childTable.Rows.RemoveAt(0);
}
// Remove this row to make the table empty for the next merge
parentTable.Rows.RemoveAt(0);
}
}
}
}
public static void GenerateDocument(Document origDoc, DataSet dataSet, string path)
{
Document subDoc = origDoc.Clone();
subDoc.MailMerge.ExecuteWithRegions(dataSet);
subDoc.Save(path);
}
If you have any further issues can you please attach your template, data source (you can save your DataSet into XML format and attach it here by using the DataSet.WriteXml method in your application) and also a quick example document of how you would want one of the outputs to look like.
Thanks,
aske012: