[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Collapse]Rich Text Editor
   [Expand]Product Information
    Product Class Structure
    Supported Formats
   [Expand]Getting Started
   [Expand]RichEditControl Document
   [Expand]Fields
    Text Formatting
    Import and Export
   [Expand]Page Layout
    Printing
    Hyphenation
    AutoCorrect
    Track Changes
    Mail Merge
    Restrictions and Protection
   [Expand]Visual Elements
    Services
    Events
    Commands
    HTML Tag Support
   [Expand]Examples
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Mail Merge

RichEditControl allows you to perform mail merge in three steps:

  1. Create or Load a Document Template
  2. Provide a Data Source
  3. Merge and Save the Document

Expanded Create or Load a Document Template

The template is a document containing fields. These fields refer to the data source's data column names.

Call the RichEditControl.LoadDocument or RichEditControl.LoadDocumentTemplate method to load a document template.

The RichEditControl allows you to add fields to the template. Call the FieldCollection.Create method to insert one of the following fields to the desired document position:

  • MERGEFIELD

    Used for plain text.

  • DOCVARIABLE

    Used for formatted content. You can use the DOCVARIABLE field to insert formatted strings or content from the RichEditDocumentServer (see RichEditDocumentServer) or SubDocument (see SubDocument) objects. Refer to the How to: Insert Dynamic Content topic for a code sample.

  • INCLUDEPICTURE

    Used for images.

    Use the INCLUDEPICTURE field as follows: {INCLUDEPICTURE "{MERGEFIELD PictureLocation}" \d} ( the PictureLocation is the path to the desired picture).

    If you need to merge different images, make sure that the images have the same name as the field's contents in the database (for example, as the "FirstName" field), and insert the INCLUDEPICTURE as follows: { INCLUDEPICTURE "PicturesLocation\{ MERGEFIELD FieldName }.jpg” *MERGEFORMAT \d }.

    Tip

    Use the IUriStreamProvider to insert pictures from a data base. Refer to the E4164 code example for details.

Refer to the Fields for an example on how to insert fields to the document.

Expanded Provide a Data Source

RichEditControl supports the following data source types:

  • System.Collections.IList;
  • System.Collections.ArrayList;
  • System.Data.DataTable.

Use the DXRichEditMailMergeOptions.DataSource property to set the data source used in a mail merge.

If the data source contains multiple data tables, use the DXRichEditMailMergeOptions.DataMember property to define a specific data member. The DXRichEditMailMergeOptions.ViewMergedData property specifies whether to display field results or field codes.

Expanded Merge and Save the Document

Use the following API to set additional merge options (the number of records, merged ranges delimitation, etc.) and merge the document:

API Description
RichEditControlOptionsBase.MailMerge Provides access to the default mail merge options.Use the richEditControl.Options.MailMerge notation to access these settings.
Document.CreateMailMergeOptions Initializes an MailMergeOptions instance, which contains additional mail merge options.
MailMergeOptions.FirstRecordIndex Gets or sets the record index from which the merge starts.
MailMergeOptions.LastRecordIndex Gets or sets the record index at which the merge finishes.
MailMergeOptions.HeaderFooterLinkToPrevious Gets ors sets whether headers (footers) in the merged document have the same content in all sections.
MailMergeOptions.NumberedListRestart Sets the behavior of numbered lists when the mail merge operation is performed.
MailMergeOptions.MergeMode Gets or sets how the merged ranges are delimited in the resulting document.
Document.MailMerge Merges the current document using the specified options, and sends the result to the specified document.

The following code uses records 1 to 3 to perform a mail merge. Each record is merged into a new section in a merged document. The target document is created in another RichEditControl (richEditControl2).

Tip

You can export each merged record to a new PDF file. Refer to the E4308 example for details.

Mail Merge Events

RichEditControl provides the following events to control specific mail merge steps:

Event Description
RichEditControl.CustomizeMergeFields Fires when the 'Insert Merge Field' command button is clicked, and enables you to customize a drop-down field list.
RichEditControl.MailMergeStarted Fires before mail merge starts.
RichEditControl.MailMergeFinished Fires when mail merge is completed.
RichEditControl.MailMergeRecordStarted Fires before each data record is merged with the document in the mail merge process.
RichEditControl.MailMergeRecordFinished Fires after each data record is merged with the document in the mail merge process.

The code sample below shows how to handle the RichEditControl.MailMergeRecordStarted event to insert and format additional content to the mail merge result:

Expanded Mail Merge Functionality in the User Interface

The RichEditControl provides the Mail Merge ribbon tab which allows end users to insert merge fields, toggle field codes and results and view the merged data. Refer to the Lesson 1 - Create a Simple Rich Text Editor topic for details on how to provide the ribbon UI for the RichEditControl.

Expanded See Also

Is this topic helpful?​​​​​​​