Automaticaly save Emails to Database


I'm looking at a New Project to be build in that links with Outlook.

Basically I want to know if it is possible (Not how to do it at this stage)

What I need to do is
Type a Email in the program
When click send it opens a New email in outlook with the receiver and the Body of the email filled in (And the Default email signature)
This needs to insert some ID
When the Email is returned it needs to automatically notify the program with the ID that was inserted into the Original Email and the New Data from the email (NOT the original email data - Just the New data).
the program will then insert this data into the SQL Database.
When the email is Replied to then the same needs to happen (The program needs to insert the details into the Database).

It needs to work simular to a ticket systems that are common these days
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

p-platerAuthor Commented:
It would also need to store any attachments that were on the Emails.
These could just be saved to a central location and a Link saved in the program
Neil RussellTechnical Development LeadCommented:
Bear in mind that outlook has security built in that will stop you from fully automating it from an external app unless you a third party product like that from MAPILabs found

But apart from that, yes it is all possible.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
p-platerAuthor Commented:

Is it also possible to send Tasks to Outlook
What about sync those Tasks both ways - So both outlook and the are kept up to date when they are updated in either Outlook or the program?

We are using a Local Exchange 2010 Server and the Tasks need to sync to the Phones and Tablets.
Neil RussellTechnical Development LeadCommented:
You can use your VB.Net program to programatically control an instance of outlook and then you can do just about anything you want.  Spend some time googling office automation and outlook.

Microsoft offer a good quick example...
C# app automates Outlook (CSAutomateOutlook)

But most importantly if you want to do things with outlook, Visit Sue Moshers site One of the earlier developers of MS Outlook.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.