Query by email 
Author Message
 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
 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
 
 [ 2 post ] 

 Relevant Pages 

1. export filmaker email fields to email app?

2. How to send emails as a result of SQL query - newbie

3. email results of DTS query

4. Query Exports to Excel then email

5. How can sql 7.0 sends results of a query with email

6. SQL to MS Exchange .. Query from email

7. Can you use SQL to receive emails and send automated reply emails

8. Emailing SQL Server Backup Failures without Microsoft Email

9. Send emails to all email addresses on my database

10. email shot to list of email address in database

11. Create Job on SQL Server that send email based on query result

12. MULTIPLE EMAIL ACCOUNTS FOR SQL EMAIL.


 
Powered by phpBB® Forum Software