Email extraction

The extraction of data from email messages
is also known as "email parsing".

Database output: File (HTML) output:

MAPI

Data Splitter uses MAPI, the Windows Messaging Application Programming Interface, to scan emails stored by Microsoft Outlook and other MAPI-based email clients.   For more information see :


EMail-basic

Loads all messages from the selected folder into database table "message".   Loads basic message items:  Sender name/email, recipient name/email, subject, date, the entire text body, and the source message store / folder names.

Contact Data Splitter support for more information.


EMail-from-mail

Loads messages with selected sender email addresses into database table "message".   Modify the "BeginsWith" and "EndsWith" string sets to filter on sender email addresses that begin with and end with the desired text.

Contact Data Splitter support for more information.


EMail-from-name

Loads messages with selected sender names into database table "message".   Modify the "BeginsWith" and "EndsWith" string sets to filter on sender names that begin with and end with the desired text.

Contact Data Splitter support for more information.


EMail-search

Identifies messages containing any of the text entries listed in the SearchText string set.   User specifies the input email folders and search items (SearchText).   Output format:  HTML file.

Installs with Data Splitter.


EMail-search-word-pairs

Identifies messages with proximate text strings, i.e. word pairs, near each other.   User specifies the input email folder list and the Word1 / Word2 string sets.   Output format:  HTML file.

Installs with Data Splitter.


EMail-to-database

Sample parser for generated emails, parses messages in selected folders and transmits selected information to the database.   This sample parses eBay "end of auction" messages and loads a table called "eauction".   It can be adapted to parse other generated emails with labeled fields.   See the Extracting data from emails topic.

Installs with Data Splitter.