MS SQL Server, Query by email

Query by email

Author	Message
J. Johns #1 / 2	Query by email Hello. I'm looking for a few opinions on 3rd party applications that can bridge (middle-ware) our SQL 7 and Exchange 5.5 servers. Specifically, I'm looking for something that can read, process, and send email. Here's an example of how I want this to work: We set up an Exchange Mailbox that is monitored by the application. End-users will be told to put one word in the Subject line (e.g., account code, security code, etc.). The application parses the Subject line (i.e., determines what it is -- account code, security code, etc.) and then executes the appropriate SQL stored procedure(s), creates an outgoing email (addressed to the sender) and formats the data (from the stored procedures) in the message body (text, rich text, or html). Any ideas on this? I have tried SQL 7's xp_readmail, etc. and found it too limiting. We have some experience using VB and Exchange/Outlook, but I don't want re-create the wheel... Thanks for your help.
Sat, 22 May 2004 06:05:20 GMT

Zachary Well #2 / 2	Query by email I'd suggest VB. As far as "recreating the wheel", it sounds like you're doing something fairly simple so you're not really recreating that much. Using CDO, along with ADO, should make this task fairly easy. You'll probably have more trouble getting it to run as a service than you will writing the app itself. Zach Quote: > Hello. I'm looking for a few opinions on 3rd party applications that > can bridge (middle-ware) our SQL 7 and Exchange 5.5 servers. > Specifically, I'm looking for something that can read, process, and > send email. > Here's an example of how I want this to work: We set up an Exchange > Mailbox that is monitored by the application. End-users will be told > to put one word in the Subject line (e.g., account code, security > code, etc.). The application parses the Subject line (i.e., determines > what it is -- account code, security code, etc.) and then executes the > appropriate SQL stored procedure(s), creates an outgoing email > (addressed to the sender) and formats the data (from the stored > procedures) in the message body (text, rich text, or html). > Any ideas on this? > I have tried SQL 7's xp_readmail, etc. and found it too limiting. We > have some experience using VB and Exchange/Outlook, but I don't want > re-create the wheel... > Thanks for your help.
Sat, 22 May 2004 06:18:19 GMT

Page 1 of 1

[ 2 post ]