Home Features Manual Download Support Purchase About      
 

EmailUnlimited Manual


Advanced Data Extraction Features

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:

Tag

Description

<*EmailGetDate*>

Gets the current system date

<*EmailGetTime*>

Gets the current system time

<*EmailGetSubject*>

Gets the email subject line

<*EmailGetText*>

Gets the email message text

<*EmailGetSenderName*>

Gets the sender's name

<*EmailGetSenderAddress*>

Gets the sender's email address

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:

First name: Alison

Last name: Kennedy

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

Look for

put into variable

First name

firstname

Last name

lastname

& lastname& ', ' & firstname

completeName

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.

(AfterDocument)
  Contact Us  
 
 


  Click here
to send an email
Call us toll-free at
1-866-EMAILUN
 
     

 

Copyright (c) 2008 by 4OfficeAutomation, Inc. | 1802. N. Carson St - Suite 108-2190 | Carson City, NV 89701