Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
09-17-2005, 11:55 AM #1
- Join Date
- Sep 2005
- Thanked 0 Times in 0 Posts
how to capture email contain into sql server
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 #2
- Join Date
- Jun 2002
- London, UK
- Thanked 110 Times in 109 Posts
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.