Step by step
To create a new recipient column in a mailing list, proceed as follows:
- Open the recipient table.
Click the (Configure columns) button and select Create new column.
A dialog box appears.
Enter a name for the new column in the dialog box.
Note: Avoid using umlauts and special characters in column names.
In the dialog box, select the appropriate column type (that is, the data type of the column):
Recipient data in this column may contain text and numbers of various string lengths (up to 255 characters).
Date and time
Recipient data in this column may contain date values and time values.
Recipient data in this column may contain date values only.
Recipient data in this column may contain time values only.
Recipient data in this column may contain whole numbers only (for example, ‘-1’ or ‘45’).
Floating point number
Recipient data in this column may contain decimal numbers only (for example, ‘3.56’ or ‘-0.75’).
Recipient data in this column may contain the values ‘Yes’ or ‘No’ (for example, if the values from radio buttons or check boxes are saved in the columns).
By selecting the appropriate column type you ensure that:
- no incorrect values are entered in the recipient data.
- specific operations can be carried out (for example, analysis of monthly values).
- target group filters and case differentiations are created more easily.
- data volumes are reduced, which means that the total speed of the system is increased.
comparisons with existing databases are simplified.Example
- Assign the ‘Text’ data type to columns that contain elements such as surnames, first names, streets or cities.
- Assign the ‘Date’ data type to columns that contain the birthday of recipients.
If you selected the ‘Text’ column type, enter the maximum allowed text length in the dialog box.
The maximum text length should not exceed 255 characters.
- Depending on the settings you specified, your new column will either appear in the current recipient table only or it will appear in all the recipient tables. If you move the mouse over the column header, you can see the column type defined for the column.