Want ColdFusion to receive emails and automatically add to SQL table
Posted on 2008-01-29
I have a concept in my head and wonder if someone can tell me if this is feasible.
Environment: We use Microsoft Exchange for corporate email. We have a customized CRM system that I wrote in CF that users can also send emails from. When sending via CRM, the email gets stored in that Customers Note table (SQL server).
Problem: Users do not want to use the CRM system to send their emails. They want to use Exchange, but want it stored in the CRM system.
My Idea: Create a CRM Contact List in Exchange comprised of each of our Customers. If the user is sending an email related to that customer to anyone, they could also select the Customer from the CRM Contact List. By doing so, this would automatically add this email into my SQL table storing the CRM Emails.
Solution: Is there some way I could create some sort of CF handler to receive the emails that have been tagged as CRM emails? To have it listening for new emails and then when one arrives, it adds a copy of that email to the SQL table.