We have designed  EmailUnlimited™ so that it prepares the data the way you need it. So we have also added a couple of advanced parameters you may use to make your form handler fit your needs even better. In order to set them up, please open the ‘Capture form data’ dialog box as described in chapter six, and enter the parameter as explained below.

How to extract additional information from your email

You can retrieve additional information from the emails in your inbox, like the subject line, message text or the time/date. Just put the appropriate tag into the ‘Look for’ column of the form handler definition table in the same row as the field name where you want the data to be stored.

You may use any of the following tags:

For example, if you want to store the subject line into a variable named Subject, write <*EmailGetSubject*> left of “Subject”.

Using this feature, you can retrieve the whole email message (except file attachments) and put it into your database. This can be very useful, e.g. if you want to create a helpdesk application.

Merge fields

Sometimes it is necessary to combine a couple of fields. Names, for example "Alison Kennedy", are often stored as "Kennedy, Alison". This is supported by the EmailUnlimited™ form handler as well.

The general syntax for merging fields is:

& FieldName1 & 'some Text' & FieldName2

Sounds confusing? Let me explain:

First of all, the tag for merging fields has to be entered into the left column of the data structures table, while the right column  contains the name of the variable where you want those merged fields to be stored.

The '&' at the beginning tells EmailUnlimited™ that it has to merge fields. Fieldname1 and FieldName2 are the names of the fields in your database. 'some Text' may contain any text that you want to be inserted .

Example:

Imagine your email messages containing the following:

Now you want the name to be stored as "Kennedy, Alison" in your database. Therefore, you create a data structure like the following:

In contrast to the other tags, you have to put the merged fields to the very end of the table, otherwise it will not work. So move to the bottom of the table where you will find an empty row, insert the merge tag into the left column and the name of the appropriate database field into right column.

As you can see from the sample table above, the value "Kennedy, Alison" will be stored into the additional field ' completeName'. The  ', ' adds the comma between the two original field values. You can put any other text between them (except the character " ), so that it fits your requirements.