October 26, 2008 at 8:46 pm
Hi all.
This one is an interesting one, and I'm fairly confident it can be done without too much trouble actually, but I can't find any documentation on INCOMING e-mails, only OUTGOING.
I was asked by our call centre manager today about the following situation:
1) A job is sent out to one of our field techs via e-mail.
2) The field tech responds by hitting the reply button, meaning they have acknowledged receiving the job
3) Behind the scenes, we have modified the reply to field to be received by a certain user or inbox that the SQL Server polls regularly (or perhaps allow return e-mails to the same sender, one setup specifically for this on the SQL Server)
4) The SQL Server polls the directory for such return e-mails, and grabs the job number from the subject line of the e-mail
5) The job number is used to find the correct job in our SQL Database, and update its status to "Assigned"
The only uncertainties for me are how to poll for these e-mails and exactly how to grab the Job No from the Subject line, but I'm pretty sure it could be done. We are using an Exchange Server onsite, so we can tap into that if we need to.
Has anyone had to do something like this, who might be able to lend some advice?
October 29, 2008 at 11:51 am
Sharon,
Look at : http://msdn.microsoft.com/en-us/library/aa155737(office.10).aspx
Using SQL Email to read mail and execute query.
Thanks,
Ben
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply