Mail Merge in Word with C# and VB.NET

Mail merge is the process of merging or importing data from a data source to a Word document. With GemBox.Document you can do a mail merge programmatically, using C# and VB.NET. In essence, the process involves replacing the Field elements of the MergeField type with values from from provided objects.

GemBox.Document exposes all mail merge related operations and options through the DocumentModel.MailMerge property.

You can read the complete documentation on the Mail Merge help page.

The following example shows how you can perform a simple mail merge by importing data from an anonymous type object.

Creating Word document with mail merge process in C# and VB.NET
Screenshot of Word file created from mail merge
Upload your file (Drag file here)
View on GitHub 
using System;
using GemBox.Document;

class Program
{
    static void Main()
    {
        // If using the Professional version, put your serial key below.
        ComponentInfo.SetLicense("FREE-LIMITED-KEY");

        var document = DocumentModel.Load("%InputFileName%");

        // Create data source for mail merge process.
        var data = new
        {
            Number = 10203,
            Date = DateTime.Now,
            Company = "ACME Corp",
            Address = "240 Old Country Road, Springfield, IL",
            Country = "USA",
            FullName = "Joe Smith"
        };

        // Execute mail merge process.
        document.MailMerge.Execute(data);

        document.Save("Mail Merge Output.%OutputFileType%");
    }
}
Imports System
Imports GemBox.Document

Module Program

    Sub Main()

        ' If using the Professional version, put your serial key below.
        ComponentInfo.SetLicense("FREE-LIMITED-KEY")

        Dim document = DocumentModel.Load("%InputFileName%")

        ' Create data source for mail merge process.
        Dim data = New With
        {
            .Number = 10203,
            .Date = DateTime.Now,
            .Company = "ACME Corp",
            .Address = "240 Old Country Road, Springfield, IL",
            .Country = "USA",
            .FullName = "Joe Smith"
        }

        ' Execute mail merge process.
        document.MailMerge.Execute(data)

        document.Save("Mail Merge Output.%OutputFileType%")

    End Sub
End Module

See also

Create Fields in Word documents using C# and VB.NET

Create Fields in Word documents using C# and VB.NET

Merge Pictures in Word Documents Using C# and VB.NET

Merge Pictures in Word Documents Using C# and VB.NET

Next steps

GemBox.Document is a .NET component that enables you to read, write, edit, convert, and print document files from your .NET applications using one simple API. How about testing it today?

Download Buy
Published: December 13, 2018 | Modified: December 19, 2022 | Author: Marek Turis