How to execute mail merge for image as Byte array in data table

Syncfusion® Essential® DocIO is a .NET Word library used to create, read, edit, and convert Word documents programmatically without Microsoft Word or interop dependencies. Using this library, you can execute mail merge for image as byte array in data table using C#.

Steps to execute mail merge for image as Byte array in data table:

1. Create a new .NET Core console application project.
2. Install the Syncfusion.DocIO.Net.Core NuGet package as a reference to your project from NuGet.org.
   
   

3. Include the following namespaces in Program.cs file
   C#

using Syncfusion.DocIO;
using Syncfusion.DocIO.DLS;

4. Use the following code example to execute mail merge for image as byte array in data table.
   C#

using (FileStream fileStream = new FileStream(Path.GetFullPath(@"Data/Template.docx"), FileMode.Open, FileAccess.ReadWrite))
{
   //Opens the template document.
   using (WordDocument document = new WordDocument(fileStream, FormatType.Docx))
   {
       //Gets the DataTable
       DataTable dataTable = GetDataTable();
       //Triggers the event
       document.MailMerge.MergeImageField += MergeField_ProductImage;
       //Performs mail merge
       document.MailMerge.Execute(dataTable);
       //Creates file stream.
       using (FileStream outputStream = new FileStream(Path.GetFullPath(@"Output/Result.docx"), FileMode.Create, FileAccess.ReadWrite))
       {
           //Saves the Word document to file stream.
           document.Save(outputStream, FormatType.Docx);
       }
   }
}

5. Use the following Helper method for event handling.
   C#

private static void MergeField_ProductImage(object sender, MergeImageFieldEventArgs args)
{
   if (args.FieldName == "Photo")
   {
       args.Picture.Height = 50;
       args.Picture.Width = 50;
   }
}

6. Use the following helper method to get data table.
   C#

private static DataTable GetDataTable()
{
   //Creates new DataTable instance 
   DataTable table = new DataTable();
   //Add columns in DataTable
   table.Columns.Add("Photo", typeof(byte[]));
   table.Columns.Add("ProductName");
   table.Columns.Add("ProductNumber");
   table.Columns.Add("Size");
   table.Columns.Add("Weight");
   table.Columns.Add("Price");
   
   //Add record in new DataRow
   DataRow row = table.NewRow();
   byte[] imageBytes = File.ReadAllBytes(@"Data/image1.gif");
   row["Photo"] = imageBytes;
   row["ProductName"] = "Mountain-200";
   row["ProductNumber"] = "BK-M68B-38";
   row["Size"] = "38";
   row["Weight"] = "25";
   row["Price"] = "$2,294.99";
   table.Rows.Add(row);
   
   return table;
}

You can download a complete working sample to execute mail merge for image as byte array in data table from GitHub.

By executing the program, you will get the Word document as follows.

Conclusion
I hope you enjoyed learning about how to execute mail merge for image as byte array in data table.

You can refer to our ASP.NET Core DocIO feature tour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our ASP.NET Core DocIO example to understand how to create and manipulate data.

For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion®, you can try our 30-day free trial to check out our other controls.

If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!