We help IT Professionals succeed at work.

Recieving mail to .NET app.

ekenman
ekenman asked
on
Medium Priority
304 Views
Last Modified: 2012-05-11
I have a Windows Forms booking system that uses a service to access data located in a central SQL Server. Ideally I would like all mail messages received to the booking-address to be stored in the SQL server so I can add information about the message, who answered it, add some intelligence when creating the booking etc.

I'd like som general guidlines on how to go about this. Is it possible to set up an Outlook client on the server and use the Outlook library to perform this task or is this a bad idea?

Any suggestions are most welcome.

Best Regards

Tomas
Comment
Watch Question

Kalpesh ChhatralaSoftware Consultant
CERTIFIED EXPERT

Commented:
you can read your pop3 mail from following link

http://www.dotnetthoughts.net/2009/03/02/reading-pop3-mailbox-using-vbnet/
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
>Ideally I would like all mail messages received to the booking-address to be stored in the SQL server

Is your question more about receiving emails automatically or storing received emails in sql server?
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
You can use custom fields in emails themselves when using Exchange/Outlook

http://www.slipstick.com/exs/customfields.htm

Author

Commented:
Thank you for your suggestions.

Kalpesh, regarding pop3 mail, there is a lot of MIME / Attachment issues with the first solution. It is to difficult.

Code Cruiser, my main object is to integrate mail handling in the booking system so that I can automate and save history in the SQL Server. If the users use Outlook or another mailprogram I can't see the history about the booking. So I guess the answer is storing received email in the sql server. It is a rather large system so it isn't an option to move it to Outlook.

The mailbox is with an ISP, but if it is the best solution I can install an Exchange Server on my server.

Best Regards

Tomas
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank's!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.