Is there a way to extract contents of an email then store the values in the database?

Question

0.00/5 (No votes)

See more:

I am using EWS (Microsoft Exchange Web Services Managed API 2.1) to accomplish this but have no idea how to start. (Note: I am using C#)

The program's functionality receives emails and extracts the body of the email given the following format:

Building: {value}
Level: {value}
Phase/Room: {value}
Request: {value}

If the user sends an email with the wrong format, the program will automatically respond with "Sorry, we cannot process blah blah blah. Use this format instead..."

If the format is correct, the program will then store the values in the database.

What I have tried:

Is this possible? I've searched a lot about EWS and parsing emails but I've never found a way to extract the values inside the BODY of the email.

I've found the closest one that does similar to what I need, but it costs you money (Email2DB.com).

Posted 25-Mar-16 21:26pm

dumbasian

Updated 25-Mar-16 21:41pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Garth J Lancaster · Accepted Answer · 2016-03-25T21:41:00

There's plenty of information about getting email body text from an email, using EWS - once you've got the body as text, why not use a Regex to parse out those values ?

Im not affiliated with, but have used products from Independentsoft to handle getting mail items and parsing a mail item into headers/body etc (their product is a lot nicer than using EWS 'native', ymmv)