View Full Version : how to capture email contain into sql server

09-17-2005, 11:55 AM
can somebody help me capture all field in email into database.for example the contain of email was like this

Thanks for registering at CodingForums.com! We are glad you have chosen to be a part of our community and we hope you enjoy your stay.


so how to capture username into username field and password into password field into sql server database

09-19-2005, 03:46 PM
This is actually possible with SQL Server and Exchange, but I can't give you much more useful information than that cos it's far too involved and I'm far too stupid. But basically you can give SQL Server a user account to get into Exchange with, and it'll be able to read all email sent to that account. Once you've actually got the two of them talking, writing some SQL to process the emails is relatively easy. Be prepared for significant hair loss in getting the two servers to talk to each other, though. And I'm not sure how, in your case, you'd go about stripping the usernames/passwords from the email body. SQL isn't really much cop as a string manipulation language. Anyway, Google "SQL Server Exchange account" or something like that if any of what I just babbled makes any sense.