Using Mail Merge with Database

[David Bush]

I am creating a program that will ask several questions to a user and give possible answers that the user will choose from.  With the answers that the user selects this will be saved to another database.  I have been trying to locate a sample of Mail Merge that uses a database (in this instance I am using SQLite) that can show how to pull the database table down and match the database entries to the form fields that are in a template. I am sure the data from the database will be stored in a data table or a List, however, I am not sure how to match the form fields from the template to the entries in the database. Does anyone have a sample that uses a database to store the users answers and match them to the form fields to Mail Merge?

Thanks in advanced.

Dave

[Sethumanikkam Yogendran]

Hi David,

Thank you for contacting Syncfusion support.

On further analyzing with the given details, we suspect your requirement is to perform Mail merge with data source in the input template. If so, you can use merge fields and data source as field values to perform Mail merge using Essential DocIO.

Kindly refer the below links to know more about working with Mail merge and group merge with data source.
UG links:
https://help.syncfusion.com/file-formats/docio/working-with-mailmerge
https://help.syncfusion.com/file-formats/docio/working-with-mailmerge#performing-mail-merge-for-a-group

Online sample link:
http://asp.syncfusion.com/demos/web/docio/employeereport.aspx

If you’re still facing any difficulties to meet your requirement, then kindly provide the following details which will helpful to provide you the solution at the earliest.
     1. Working scenario along with the sample or complete code snippet used at your end.
     2. Input template document (if any) used.
     3. Data set (dummy) used for Mail merge process.
     4. Screenshot of your output or expected output document.

Please let us know if you have any other questions.

Regards,
Sethumanikkam.Y