The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

IWorkbook.GenerateMailMergeDocuments() Method

Performs the mail merge and returns the collection of resulting workbooks.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

IList<IWorkbook> GenerateMailMergeDocuments()
Function GenerateMailMergeDocuments As IList(Of IWorkbook)
IList<IWorkbook> GenerateMailMergeDocuments()
Function GenerateMailMergeDocuments As IList(Of IWorkbook)
IList<IWorkbook> GenerateMailMergeDocuments()
Function GenerateMailMergeDocuments As IList(Of IWorkbook)

Returns

Type Description
IList<IWorkbook>

An IList object that contains workbooks generated after the mail merge is preformed.

Returns

Type Description
IList<IWorkbook>

An IList object that contains workbooks generated after the mail merge is preformed.

Returns

Type Description
IList<IWorkbook>

An IList object that contains workbooks generated after the mail merge is preformed.

Remarks

The manner of generating the mail merge result depends on the used mail merge mode.

Mail Merge Mode Mail Merge Result
Multiple Documents Each data record is merged into a separate workbook. So, the mail merge results in as many workbooks as there are records in the specified data member (IWorkbook.MailMergeDataMember) of the bound data source (IWorkbook.MailMergeDataSource).
Multiple Worksheets Each data record is merged into a separate worksheet in a single workbook. So, the mail merge results in a single workbook.
Single Worksheet All data records are inserted one after the other into a single worksheet. So, the mail merge results in a single workbook.

When performing the mail merge, you can sort, group and filter data to appear in resulting documents.

See Also