Mail merge Word file and Excel data in C#

Fast .NET library to execute Mail merge with Excel data.

Our Mail Merge SDK allows you to populate a Word template with your data from Excel sheet. Based on our Mail Merge API, you can create your own software solution using .NET, which allows you to automate emails from Excel and generate reports with Excel data.

To Mail merge from Excel to Word, simply perform the Mail merge operation in C# and export the result to any supported Word formats.

Mail merge from Excel to Word using C#

With our powerful Mail merge API, you can create personalized documents in C# using just a Word Merge template and data from Excel.

How to use Mail merge from Excel:

Create a Word template with special merge fields into which your data from Excel will be inserted.
Convert Excel document to CSV file and then to JSON file suitable for parsing by our API.
Perform the operation of Mail merging the Word template and data converted from Excel to CSV and then to JSON.

Mail merge with Google Docs

With our high-fidelity Mail merge API, you can also perform a Mail merge operation with Google Docs. Just download the necessary data in Word and Excel format, make sure that the Word template contains merge fields and perform the Mail merge operation in C#, similar to the algorithm described in the previous section.

To try this powerful Mail merge web tool, load a Word template with special merge fields and data from Excel converted as described above. After running the code, export the result to any format using C#.

The following example shows how to perform a Mail merge operation to generate a Word document in C#:

Execute a Mail merge operation using docx template in C#

Input files

Upload a Mail merge template

Run code

Upload Mail merge data

Output format

Select the target format from the list

dotnet add package Aspose.Words

Copy

using Aspose.Words;
using Aspose.Cells;

var doc = new Document("Input1.docx");
var workbook = new Workbook("Input2.xlsx");
var worksheet = workbook.Worksheets[0];

var dataTable = worksheet.Cells.MaxDisplayRange.ExportDataTable(
   new ExportTableOptions { ExportColumnName = true });
doc.MailMerge.Execute(dataTable);

doc.Save("Output.docx");
            

					Run code
				

You may freely download this code or copy it in any applicable purpose

How to use Mail merge in docx files

Install Aspose.Words for .NET.
Add a library reference (import the library) to your C# project.
Create a docx merge template with merge fields.
Open the template file in C#.
Call the Execute() method, passing the merge fields and their values there.
Call the Save() method, passing an output filename with required extension.
Get the result of Mail merge operation as Word file.

C# library to use Mail merge in docx

There are three alternative options to install "Aspose.Words for .NET" onto your system. Please choose one that resembles your needs and follow the step-by-step instructions:

Install a NuGet Package. See Documentation
Install the library using Package Manager Console within Visual Studio IDE
Install the library manually using Windows Installer

System Requirements

Our product is fully cross-platform and supports all major .NET implementations:

.NET ≥ 5.0
.NET Core ≥ 2.0
.NET Standard ≥ 2.0
.NET Framework ≥ 3.5
MonoMac
MonoAndroid
Xamarin

As far as .NET code doesn't depend on the underlying hardware or operating system, but only on a Virtual Machine, you are free to develop any kind of software for Windows, macOS, Android, iOS and Linux. Just make sure you have installed the corresponding version of .NET Framework, .NET Core, Windows Azure, Mono or Xamarin.

We recommend using Microsoft Visual Studio, Xamarin, and MonoDevelop integrated development environments to create C#, F#, VB.NET applications.

Fore more details please refer to Product Documentation.

You can perform Mail merge operation for other file formats:

Mail merge DOCX

Mail merge MUSTACHE

Mail merge WORD

Create docx using Mail merge in C#

High-speed .NET library for merging document templates and user data into files of various formats