Second attempt. Does anyone know how to extract data from mail?

  • Thread starter Thread starter Allen Clark
  • Start date Start date
A

Allen Clark

I have thousands of mail messages being sent by my web API that has smalll
amount of useful information in the message body. The following is an
example:

Tessitura.WebAPI.TessituraException: TESSITURA_INVALID_SESSION_EXCEPTION:
The session specified does not exist. SESSION KEY:

Time Sent: 2009-10-16 16:27:17.9735426

There are three pieces of information that I would like to capture to a csv
file or a sql table. These are: The Exception, the session key, and the
time sent. The rest of the information in the e-mail is completely useless.
I need to extract this information from the message body from every message
that gets sent to a particular folder (or run against existing messages in
said folder). I am NOT looking for a utility to extract e-mail addresses, IP
addresses, or anything else from these messages, nor am I trying to capture
anything from the message header. Can anyone provide me with any assistance?
Can it be done in PowerShell? C++, C#, VB, JAVA...?

Thanks in advance,
Allen
 
Yes its possible to extract the data (egrabber and others capture content
from the message body) - I don't think powershell will work, you'll need
VB/VBA. I think c++ or C# will work as well. Start at outlookcode.com or the
outlook programming groups on this server.

--

Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]
 
There are many ways to accomplish what you want. If you want to chat more
about this contact me at: jlpingree<at>hotmail.com
 
Have you checked to see if the process that generates the emails can grab
the information and drop it into a database from the get-go? Doing so will
ensure that the information is captured, eliminate the need to create a
client-side solution, dramatically cut down on the clutter in your mailbox
and be consistent with the concept of data capture at the point of contact.
 
Back
Top