Does anyone know of any 3rd party email modules avaialable that monitors a SQL Server table for new 'emails to send' entries, and then sends them?

I have an enterprise application that uses SQL Server replication to keep data in sync between my colocated website and my local office database - I would like to be able to initiate sent emails on the client side by simply dropping a row in a database table - that way I don't need to worry about the reliability of the local network, or the configuration of SMTP relays, as the web server is already set up to send emails. - and in the event that the local connection goes down - it will eventually come back and replication will catch up.

I know that I could set up a local SMTP relay - but up until now the only communication or configuration that needs to take place between the web server and the local facility is SQL Replication; and as I will be rolling this product out to multiple clients very soon - I would like to keep the connectivity side as simple as possible.

I will probably just end up writting a quick app that uses the DNN Scheduler to check a table and send unsent emails every few seconds - but I thought I would first ask to see if anyone has already done this work.

Thanks for your replies.

Matt

How about a trigger that sends the mail?