Create a Letter
- 2 minutes to read
This tutorial describes the steps to create a mail merge report, in which data fields are embedded into a label’s text that is replaced with corresponding data values on preview or export.
Do the following to create a mail merge report:
- Start Microsoft Visual Studio 2012, 2013, 2015, 2017, or 2019 and create a new application under any of the supported platforms, or open an existing one.
- Add a new blank report to it.
- Bind the report to the “SalesPerson” view of the sample Northwind database (nwind.mdb file, which is shipped with the XtraReports installation).
Drop the XRRichText control from the DX.22.1: Report Controls Toolbox tab onto the Detail band.
Add the required text to the control and embed data fields’ names into it, surrounded by [square brackets], as shown in the following image:
To apply a formatting to the embedded data fields, set the cursor to a field’s name inside the square brackets, and click the control’s smart tag. In the invoked actions list, define the required value for the Format String property.
If your project in Visual Studio 2022 has to connect to Microsoft Access databases, note that Visual Studio 2022 is a 64-bit process, and Microsoft OLE DB Provider for Jet and the Jet ODBC driver are only available in 32-bit versions. It is recommended that you use the 64-bit Microsoft Access Database Engine (Access Connectivity Engine, ACE), or use an earlier version of Visual Studio (VS 2019) that supports 32-bit database providers. For more information, review the following article: Connect to data in an Access database.