 How does it work - Data Panel |
|
 |
|
| |
|
In this panel You define the form and/or the recordset to get the data value to send the e-mail.
When You find this icon  You can get the value for the field from the Form Field or fron the Recordset Field.
You can send the e-mail to a single e-mail address or to a list from a recordset.
You can also mix the two method (get some data from the form and some data from the recordset.
If a recordset is present will be send an e-mail for each record. |
| |
|
Form |
Select the form |
|
|
Connection |
Write a new DB connection |
|
|
Sql |
The SQL to define the recordset |
|
|
Write SQL Button |
Open the SQL writer panel.
A panel to write SQL like my extension Professional Query Manager |
|
|
Test SQL Button |
Click Test to connect to the databse and create an instance of the data source. A table appears displaying the returned data. Each row contains a record and each column represents a field in that record. |
| |
|
|
Set the dynamic value for the field |
| |
|
|
