Settings

Title

Into this field, enter the message title.

WARNING This field is mandatory when sending e-mail messages.

Sending Method

You can choose between three methods of sending:

• SMS: only sends SMS messages. When selected, only the subjects that have their phone number entered in the Subjects register appear on the Send Message tab.
• E-Mail: only sends e-mail messages. When selected, only the subjects that have their e-mail address entered in the Subjects register appear on the Send Message tab.
• SMS or e-mail: first, the program checks whether a phone number for sending SMS messages is listed on the subject in the Subjects register, if it does not exist, the program checks if there is an e-mail address.

If only a phone number exists, the program will send an SMS message. If only an e-mail address exists, the message will be send by e-mail. If both a phone number and e-mail address are listed in the register, the program will send an SMS.

User SQL

This field contains the predefined SQL query for collecting data about subjects for sending SMS messages or e-mails. The result of the SQL query is visible on the Send Message tab, where the program displays the list of subjects with suitable data for sending (phone number or e-mail address).

HINT The SQL query can be changed and written according to the user's needs. The following fields are mandatory: aacSubject, anUserid, acContactName, acContactSurname, acPhoneNumeric, acEmail, acMarked Optical parameters: nSmsMailGatherQId (automatically filled in from the main range of data tMN_SendSmsMail.anQId).

(Restore Default SQL)

Clicking the button restores the default SQL query, if it was changed in the field.