How to perform mail merge in column wise in a Word document?

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 perform mail merge in column wise in a Word document using C#.

To merge different data into the same merge fields in a column-wise manner, create a template Word document by following these steps.

• First, create a table with two columns and add merge fields in both cells of the first row.
• To insert the next record in the second column, include the Next field after the merge field in the first cell. Once the mail merge is executed, the first cell will display the first record, while the second cell will display the next record.

Note: To see the Next field in template document, press ALT + F9 in Microsoft Word to toggle field codes.

Steps to perform mail merge in column wise in a Word document:

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.DLS;
using Syncfusion.DocIO; 

4. Use the following code example to perform mail merge in column wise in a Word document.
   C#

//Open the file as Stream.
using (FileStream fileStream = new FileStream(Path.GetFullPath(@"Data/Template.docx"), FileMode.Open))
{
   //Get the data for mail merge.
   DataTable table = GetDataTable();
   //Iterate to the each row and generate mail merged document for each rows.
   for (int i = 0; i < table.Rows.Count; i++)
   {
       //Load file stream into Word document.
       using (WordDocument document = new WordDocument(fileStream, FormatType.Docx))
       {
           //Executes mail merge using the data row.
           document.MailMerge.Execute(table.Rows[i]);

           //Create a file stream.
           using (FileStream outputFileStream = new FileStream(Path.GetFullPath(@"Output/" + "Record_" + (i + 1) + ".docx"), FileMode.Create, FileAccess.ReadWrite))
           {
               //Save the Word document to the file stream.
               document.Save(outputFileStream, FormatType.Docx);
           }
       }
   }
}

5. Use the following code example to create a data to execute mail merge in Word document.
   C#

public static List<CustomerDetail> GetCustomerDetails()
{
   List<CustomerDetail> customers = new List<CustomerDetail>();
   customers.Add(new CustomerDetail("Sathish Kumar", "F3, Bharath PST Castle,", "14, Renga Nagar, Srirangam", "Trichy,", "Tamilnadu", string.Empty));
   customers.Add(new CustomerDetail("Swathi", "No12, DN Aparments", "15, Thillai ganga nagar", "Chennai,", "Tamilnadu", string.Empty));
   customers.Add(new CustomerDetail("Brent", "#12, London Road", string.Empty, string.Empty, "Oxford,", "United Kingdom"));
   customers.Add(new CustomerDetail("Mani", "#12, Steve Lane,", string.Empty, string.Empty, "Dublin,", "Ireland"));
   return customers;
} 

6. Use the following class to maintain customer details.
   C#

public class CustomerDetail
{
   public string Name { get; set; }
   public string Address1 { get; set; }
   public string Address2 { get; set; }
   public string City { get; set; }
   public string Region { get; set; }
   public string Country { get; set; }

   public CustomerDetail(string name, string address1, string address2, string city, string region, string country)
   {
       Name = name;
       Address1 = address1;
       Address2 = address2;
       City = city;
       Region = region;
       Country = country;
   }
} 

You can download a complete working sample to perform mail merge in column wise in a Word document from the GitHub.

Take a moment to peruse the documentation where you can find basic Word document processing options along with the features like mail merge, merge, split, and compare Word documents, find and replace text in the Word document, protect the Word documents, and most importantly, the PDF and Image conversions with code examples.

Conclusion

I hope you enjoyed learning about how to perform mail merge in column wise in a Word document in .NET Core Word document.

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!