Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Spreadsheet Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Printing
    Events
   [Collapse]Mail Merge Overview
     Mail Merge Ribbon Tab
     Mail Merge Design View
     Field List Panel
     Parameters Panel
     Data Source Wizard
     Mail Merge Functions
     Template Document
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Mail Merge Ribbon Tab

The Mail Merge Ribbon page contains various command buttons that can be useful when creating a mail merge template.

  • External Data Sources

    You can invoke the Data Source Wizard to add new external data source, select one of the existing connections or data sources and configure it. You can create and modify queries using the Query Designer and specify table relations using Master-Detail Relations Editor.

  • Multiple Documents, Multiple Sheets, Single Sheet

    Three modes are available to specify whether data records should be merged into separate workbooks, separate worksheets in a single workbook, or a single worksheet.

  • Document Orientation

    You can specify the direction in which the detail level will be repeated in the resulting report.

  • Template Ranges

    Detail, header and footer ranges can be specified in a mail merge template. Template ranges are used for specifying the structure of a resulting worksheet, as well as for sorting, grouping and filtering data. You can also create complex master-detail reports by adding nested levels within a detail range to merge data from child data members of a hierarchical data source.

  • Sort & Group

    You can sort data in each detail range individually, and split sorted data into groups based on identical values in data fields by creating group headers and footers. See the How to: Sort Data and How to: Group Data examples.

  • Filter

    You can filter data in each detail range individually. See the How to: Filter Data example.

  • Mail Merge Design View

    You can use the special Mail Merge Design View to modify the template structure visually.
  • Mail Merge Preview

    You can preview how a document is generated and filled with data after mail merge is performed. Note that if the Multiple Documents mail merge mode is used, only the first merged workbook is shown in the preview window.

To add the Mail Merge page to the Ribbon UI, click the SpreadsheetControl's smart tag and select Mail Merge from the invoked SpreadsheetControl Tasks menu. Note that if you select Create All Bars in this menu, the Mail Merge tab is not generated.

How would you rate this topic?​​​​​​​