Exchange Server 2007 Emails Executing SQL Server 2005 Stored Procedure
I have sales representatives that like to look up the lateste pricing information on customers we are servicing on a regular basis. Instead of them calling our office I would like them to send an email to our Exchange Server that, based on the coded string they enter in the subject line, automatically emails them the latest pricing information from our SQL Server. I have the stored procedure written in the SQL Server that accepts the values passed to the variables of @CodeString varchar(50) and @EmailUserName varchar(60). I can also send the email from within the SQL Server Stored Procedure. What I can't figure out is how to call the stored procedure and pass it the values from the email, subject line and sender email address, once the Exchange Server 2007 receives the email. Can someone set me along the path to figuring this out please? Thank you in advance.
May 27th, 2008 5:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics