H2O allows you to create custom email templates that are used to email the person completing a form, a team member or when a new comment has been added to a completed form. You can edit these templates from the Project Details screen of the core H2O Module for the project associated with your H2O form.
Form Values in Emails: To have these emails include form values, edit the projects Email Template and place tags in the email where you want the forms control value to be displayed. For example, if you have a control named FirstName then you would add the tag [CST::FirstName] to the email. Double-check the Raw/Text of the email template to make sure there aren't any HTML codes in the tag.
Control tags must be formatted with brackets and the CST:: tag. [CST::ControlNameHere]
Custom Email Subject: To define your own subject of the emails H2O sends out, add a Hidden Field (you can apply this to any control, using a Hidden Field control named after this function may make it easier to find in the future if you should need to update it. The Form Editor also includes a list of controls that contain H2O Script to make finding your H2O Script enabled controls easier.) In the H2O Script of the control, type EMLSUBJ:YOURSUBJECTLINEHERE and replace the "YOURSUBJECTLINEHERE" with your custom subject that you want your emails to include when H2O processes emails.
Custom Dynamic Email Distribution List: You can define a custom email distribution list in the Project Details screen in the core H2O Module for the project associated with your H2O form. Open your project and scroll down to the 'Additional Email Notification List' box and enter a SQL Statement that returns the email addresses. This allows to you to create an email distribution list that may change over time (new users, changes in members assigned to specific DotNetNuke roles, etc). An example SQL Statement: "Select Email From Users"
Email Notifications Based on a Controls Values: To have emails sent to a custom distribution list when a form is saved, add a control to your form (or use an existing control that does not contain H2O Script) and use the H2O Script EMAILVB-EMAILLISTHERE and replace EMAILLISTHERE with your custom email distribution list. This H2O Script function appears on the Functions list in the Form Editor when you have a Label control selected. Example: If you want to email JohnDoe@dnnmodule.com when the control IsApproved equals True (assuming this control is a checkbox) then you would use the following H2O Script: EMAILVB-JohnDoe@dnnmodule.com;True