The purpose of this application is to create an email template (title, subject, body) and store it into a database table. When an email is needed to be sent, the application queries the database table and gets the subject and body of the email from the database table. The emails are also associated to specific database records and therefore fields from these records may be used in the email.
The email subject and body of the email may contain dynamic parameters. These parameters are replaced with actual values when sending out the email. The purpose of these dynamic parameters is to allow the email to be personalized instead of sending a generic email. The dynamic parameters are available in the SQL table. When creating the email template, the parameters may be placed in the subject or body. When the email is actually sent out the dynamic parameter should be replaced with actual values. The actual values are available in a database table.
An email is sent when an event occurs. Example: User submits a ticket from a web site. A ticket is assigned to a technical staff. A ticket is closed by technical staff. When these events occur, if there is an email template associated to that event, the email must be sent out.