Hello, I want to insert documents from database to another documents by mail merge.
I’ve find this code in the forum and I’m looking for it
But how can I use this function to build the document report.
private void HandleMergeFieldEvent(object sender, MergeFieldEventArgs e)
{
//This creates a new document builder for every event.
//Although DocumentBuilder is a lightweight object, it still
//might be better to cache it in a field of this class.
DocumentBuilder builder = new DocumentBuilder(e.Document);
if (e.FieldName == "Description")
{
builder.MoveToMergeField(e.FieldName);
string fieldValue = e.FieldValue.ToString();
if (fieldValue.IndexOf("Blue") != -1)
builder.Font.Color = System.Drawing.Color.Blue;
else
builder.Font.Color = System.Drawing.Color.Red;
//Write the text using the builder, don’t let the mail merge engine to insert text too.
builder.Write(fieldValue);
e.Text = "";
}
}
Thank you for your reply,
The differend is my documents is not stored on a blob fields but I’ve a single document stored in disk server.
I read this document, extract the appropriate section and insert it to my report document.
So simply replace the LoadDocumentFromBlobField method with a code that extracts the section from your document. The details depend on the way you perform the extraction.
Do you really need to use the TextePrepa field? I think it’s redundant. You can populate the Code fields with the extracted sections. By the way, I guess you could simply extract plain text enclosed in [ ] since there is no need to copy multiple sections:
void DoMerge(DataTable table)
{
Document doc = new Document("template.doc");
doc.MailMerge.MergeField += new MergeFieldEventHandler(MailMerge_MergeField);
doc.MailMerge.ExecuteWithRegions(table);
}
void MailMerge_MergeField(object sender, MergeFieldEventArgs e)
{
e.Text = ExtractPlainText(e.FieldValue);
}
string ExtractPlainText(string sectionName)
{
// Here we search the string —sectionName— in the second document
// and return the text located between square brackets
}
Here is a working console application that shows how you can solve your problem. The only thing you should change is to pass your own DataTable object to the DoMerge method.
The main disadvantage of the application is loosing text formatting when inserting it into the bookmarks. If you still need to keep the formatting, I think you should place the source sections into separate documents instead of keeping it in the same doc. It will significantly simplify the code. Please tell me if it suits you and I’ll update the sample.
using System;
using System.Data;
using System.Text.RegularExpressions;
using Aspose.Word;
namespace ConsoleApplication
{
class Class1
{
static Document docWithSections;
[STAThread]
static void Main(string[] args)
{
docWithSections = new Document("sections.doc");
DataTable table = new DataTable("Test");
table.Columns.Add("Code", typeof(string));
table.Rows.Add(new object[] { "PREPLAVAGEHP" });
table.Rows.Add(new object[] { "PREPREPRISEMACON" });
DoMerge(table);
}
static void DoMerge(DataTable table)
{
Document doc = new Document("template.doc");
doc.MailMerge.MergeField +=
new MergeFieldEventHandler(MailMerge_MergeField);
doc.MailMerge.ExecuteWithRegions(table);
doc.Save("result.doc");
}
static void MailMerge_MergeField(object sender, MergeFieldEventArgs e)
{
e.Text = ExtractPlainText(e.FieldValue.ToString());
}
static string ExtractPlainText(string sectionName)
{
string input = docWithSections.Range.Text;
string pattern = @"-+\s*" + sectionName + @"\s*-+.*[(?.+)]";
Match match = Regex.Match(input, pattern, RegexOptions.Singleline);
if (match.Success)
return match.Result("${text}");
return null;
}
}
}
Okay. So create the separate documents, put the sections there and give them names of the sections, e.g. PREPLAVAGEHP.doc. We’re back to the sections copying in order to preserve the formatting. Here’s the updated application:
using System;
using System.Data;
using System.IO;
using Aspose.Word;
namespace ConsoleApplication
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
DataTable table = new DataTable("Test");
table.Columns.Add("Code", typeof(string));
table.Rows.Add(new object[] { "PREPLAVAGEHP" });
table.Rows.Add(new object[] { "PREPREPRISEMACON" });
DoMerge(table);
}
static void DoMerge(DataTable table)
{
Document doc = new Document("template.doc");
doc.MailMerge.MergeField += new MergeFieldEventHandler(MailMerge_MergeField);
doc.MailMerge.ExecuteWithRegions(table);
doc.Save("result.doc");
}
static void AppendDoc(Document dstDoc, Document srcDoc)
{
while (srcDoc.Sections.Count > 0)
{
Section section = srcDoc.Sections[0];
srcDoc.Sections.RemoveAt(0);
dstDoc.Sections.Add(section);
}
}
static void MailMerge_MergeField(object sender, MergeFieldEventArgs e)
{
string fileName = e.FieldValue.ToString() + ".doc";
if (!File.Exists(fileName))
return;
Document doc = new Document(fileName);
AppendDoc(e.Document, doc);
e.Text = String.Empty;
}
}
}
Thanks, how have you defined your mail field in template.doc.
Me I define mergefield and “TableStart:Test” “Code” “TableEnd:Test” but sections in PREPBETREVORGCONS.doc and PREPLAVAGEHP.doc are not inserted.
But it only insert this lines
I simulate your data table, you have to pass your own one. And don’t forget to put the docs into the bin/Debug subdirectory or specify the path when constructing the file name of the document being processed.
Thanks,
I think that it is because I’ve cathed the line doc.Save(“result.doc”);
But if I don’t catch this line, I have error Access Denied pointed to this line Why ?
You need to specify path where you save the file, otherwise you don’t know where it gets saved, maybe in System32 where you probably don’t have permissions.
This happens because you should import a section (and any node actually) to the destination document using Document.InsertNode. We have a number of code samples in Aspose.Words documentation that show how to perform the insertion properly, please take a look: https://docs.aspose.com/words/net/insert-and-append-documents/