Forum OpenACS Q&A: How to send and receive emails from SQL Server 2000

Collapse
1: How to send and receive emails from SQL Server 2000
Posted by Shaunak Thaker on 04/25/02 03:57 PM
Hi Freinds,

I want to know How to send and receive emails from SQL Server 2000

Thanks

Collapse
2: Response to How to send and receive emails from SQL Server 2000 (response to 1)
Posted by defunct defunct on 04/25/02 03:59 PM
I expect Microsoft would also be interested in how to do that reliably 😊
Collapse
3: Response to How to send and receive emails from SQL Server 2000 (response to 1)
Posted by John Sequeira on 04/26/02 02:30 AM
Shaunuk,

Sending emails the MS way requires a MAPI client (Outlook) running on the server.  Alternatively,  you can use xp_cmdshell and blat or some other command line utility (I like perl).  You can also use CDONTS or ServerObjects ASPQueueMail with the OLE system stored procedures.

Receiving usually entails running a scheduled agent or DTS job to read from your POP server and write messages into your DB tables.

I would make the general suggestion that you're posting your ms stuff on the wrong board.  Try Microsoft's mssql server newsgroups - more knowledge ms-heads hang out there.