[Webinar] Streamline your web hosting managementRegister Today


Want ColdFusion to receive emails and automatically add to SQL table

Posted on 2008-01-29
Medium Priority
Last Modified: 2012-06-27
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.
Question by:sulzener
  • 2
LVL 36

Expert Comment

ID: 20782182
I don't use exchange so take this fwiw...

firstly, this would be a whole lot easier if you upgrade to CF8...it has built in Exchange connectivity and would probably make this fairly trivial... http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=cfexchange_2.html

for this to work at all with previous versions you'd need to set up Exchange to deal with POP3...
you could probably get cfPOP to getHeaderOnly and store that info into the db, however you'd have to set up a cfpop connection for each email address that could be receiving the crm related emails (there's no global way of reading multiple inboxes via POP3)

Probably not practical without CF8


Author Comment

ID: 20788017
Sidfishes, I am willing and ready for CF8.  I just needed an excuse.  This may be it.  I still cannot conceptualize what you suggested.  Not even sure I know if what I am asking is feasisble.  I would like to make it so simple for are user community to send emails and be able to save it in the CRM notes/email area.  My thought is to have a special email for each customer and when they send the email to that account, it gets scooped off and stored in CRM.  Can you think of a better way?  Do you still think I can accomplish this with CF8?  
Would I have a CF Scheduled Task program  and periodically check exchange inboxes for each of the customers?  Can I remove the message once I add it to CRM tables?  
Thanks for your comments.
LVL 36

Accepted Solution

SidFishes earned 2000 total points
ID: 20788401
I can't be as much help as I'd like since I don't use exchange but I think you could do what you want
It looks to me as if you would have full access to all exchange folders so would be able to search for your tagged emails. Specifically look at  Getting Exchange items and attachments in the link below

Check out the exchange integration info for CF8 here http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=cfexchange_2.html

I'd suggest getting the free dev edition of CF8 and start playing


Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are literally thousands of Exchange recovery applications out there. So how do you end up picking one that’s ideal for your business & purpose? By carefully scouting the product’s features, the benefits it offers you, & reading ample reviews f…
There’s hardly a doubt that Business Communication is indispensable for both enterprises and small businesses, and if there is an email system outage owing to Exchange server failure, it definitely results in loss of productivity.
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses

613 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question