Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2003-01-14 : 12:51:29
|
| I want to set up an [in box] for each of my users in my usertable. Each of these user currently have an email user@company.com. They will continue to use this for communication out. However, our application needs to receive email and route to the correct user. How can I set up SQL to accept incoming email, with files and route to user@application.com. Would you suggest SQL MAIL. Email does not have to be HTML and they only need to receive mail.We are currently sending email through CDONTS. I really don't want to set up an EXCHANGE server to do this.Thanksslow down to move faster... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-14 : 13:07:03
|
| Let me ask this question: would you use an Exchange server to store database info?Maybe that's not gonna help you, but I can't help thinking that you're using the wrong tool for the job in making SQL Server handle email. You're always gonna be fighting to get SQL Server to do what you want. Just set up a real email server and let it do what it was designed to do. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-01-14 : 14:24:02
|
| Expanding on Rob's comments, I worked in a company a while back where we processed incoming mail (primarily looking at bounce notices). We had an Exchange server that received everything. Then we wrote a VB app to read through that particular inbox, scan the message body for certain key values, and process it by either forwarding to another person, or logging information into our SQL Server database. But it was a constantly running VB app that really handled the "sort and process" logic.------------------------------------------------------The more you know, the more you know you don't know. |
|
|
|
|
|
|
SQL and Incoming MAIL