Send E-mail To Recipients From Recordset

This trigger allows the site developer to send an e-mail message to multiple recipients when a form is submitted. By recipients, we understand the contacts (people, departments, companies) the site developer has, contacts whose e-mail addresses are stored in the database. The table column that contains the e-mail addresses will have to be included in a recordset before applying this trigger (thus the name of the trigger).

Note: The Send E-mail To Recipients From Recordset server behavior should not be used with large numbers of recipients, because you will not have perfect control over the mailing queue. Depending on your mail server configuration, the execution time might expire, if your mailing queue is very long. For a professional newsletter solution, we recommend MX Newsletter, which gives you perfect control over the mailing queues and has an optimized e-mail sending process.

Send E-mail To Recipients From Recordset is an AFTER trigger, and it requires the existence of an insert/update/delete/custom transaction and of a previously created recordset.

This trigger is accessible from the Application panel, Server Behaviors -> + -> MX Kollection -> Send E-mail -> Send E-mail To Recipients From Recordset.

The user interface is divided into three (or four) tabs, depending on the MX Kollection version that you have installed:

• The Main tab - set the basic e-mail options here: sender, receiver, message and subject.

• The Options tab - set more advanced e-mail options, like format, carbon copies and importance.

• The Attachments tab - available only in MX Kollection 3 Professional, allows defining rules for attaching files to a message.

• The Advanced tab - define trigger importance and starting time.

You can learn how to configure each of the interface tab in the sections below.

The Basic tab

Allows defining the basic e-mail options.

To set the dialog box options for the first tab, follow the next steps:

1. In the Recordset drop-down menu select the recordset that you had previously created (and that contains the database table column which stores the e-mail addresses).
2. In the E-mail to field drop-down menu select the field that contains the e-mail addresses of the recipients to whom you will send an e-mail message.
3. In the From text box enter the administrator's/sender's e-mail address. The default option is the one set in your e-mail settings. If you haven't edited it in the InterAKT Control Panel, then your sender's address is nobody@nobody.com. You can add dynamic data in the text box by using the InterAKT Dynamic Data feature.
   
   Note: If you used a certain sender in your From field and later on apply the same server behavior, wanting to go back to the default sender, type in the From text box: {KT_defaultSender} (you will notice that your previous choice will be displayed there due to the user interface persistence). Learn more about the InterAKT mark-up language by reading the description given here.
4. In the Subject text box type the title or subject of the e-mail message. This text box also benefits from the InterAKT Dynamic Data facility.
5. In the Body drop-down menu select one of the two available options: Write content or Retrieve content from file. Depending on your choice, the last field of the interface will present differences. To see how to configure this last field, see the Content or File fields.
6. The three buttons in the top right corner of the interface offer you the next functionalities:
   · Click OK when you are done configuring the trigger.
   · Click Cancel to exit without applying the new settings.
   · The Help button opens this help page.
   These buttons are common to all three tabs of the Send E-mail To Recipients From Recordset trigger interface.
7. Click on the Options tab to continue configuring the trigger.

The Options tab

Define the e-mail format, carbon and blind carbon copies and importance.

For instructions on completing this step, see the Options tab.

The Attachments tab

This tab of the user interface is only available in the MX Kollection 3 Professional version and allows the user to select files that will be sent with the e-mail message as attachments.

Configure the user interface options as shown below:

1. The Attachments grid displays all of the attachment rules defined for the current server behavior. You can add and remove attachments by using the Plus (+) and Minus (-) buttons on top of the grid. Fill in each rule's options by selecting it in the grid and filling in the fields below.

2. In the Folder field enter the relative path to the folder storing the file(s) you wish to send. You can use the Browse button to select the folder from the site structure. The path to the folder will be displayed relative to the current document.

3. In the Field drop-down menu select which of the transaction fields stores the file name. If not using a recordset, or using a custom naming, select the None: Rename rule option.

4. In the Renaming rule text field enter the name of the file to attach. This field is enabled only when using the Rename rule option, and allows you to enter static and dynamic data which will compose the name of the file. You can either enter InterAKT Mark-up directly or use the InterAKT Dynamic Data icon to visually select it.

The Advanced tab

On the last and optional tab of the user interface, configure the trigger properties: transaction to attach to, priority and when to execute it.

For instructions on completing this step, see the Advanced tab.