SharePoint Discussion List e-mail Reciver Parser- event handler code sample SharePoint Discussion List e-mail Reciver Parser need to parse in-coming messages and place 4 data itmes in 4 columns in an excel file to auto-reply.  Can you dislplay sample code of such a parser? an event that receiving an e-mail will trigger automatically?<br><br>Following is the e-mail content:<br> <h2> <center>Results for 2_Questions_Test_Export_As_Test_Show_Score_to_Students</center></h2> <table> <tbody> <tr> <td><b>Student Name:</b></td> <td>First LastNmae</td></tr> <tr> <td><b>Student ID:</b></td> <td>ID1234567890</td></tr> <tr> <td><b>Score:</b></td> <td>1 / 2 points (50%)</td></tr></tbody></table> <p>Your test results have been sent to Dr. S. Rush at <a href="mailto:s.rushinek@miami.edu">s.rushinek@miami.edu</a>. At this time, you can quit your browser or link to another page.<br>Parse copy and paste into an excel spreadsheet:<br>A                B                        C                D<br> <table style="width:528pt;border-collapse:collapse" cellspacing=0 cellpadding=0 width=704 border=0> <colgroup> <col style="width:48pt" span=11 width=64> <tbody> <tr style="height:15pt" height=20> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;height:15pt;background-color:transparent" width=64 height=20><font face=Calibri><strong><em><u>1 Name</u></em></strong></font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64><font face=Calibri><strong><em><u>ID</u></em></strong></font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64><font face=Calibri><strong><em><u>Grade</u></em></strong></font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64><font face=Calibri><strong><em><u>Test</u></em></strong></font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td></tr> <tr style="height:22.5pt" height=30> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;border-bottom:#f0f0f0;height:22.5pt;background-color:transparent" height=30><font face=Calibri>2 First LastName</font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;border-bottom:#f0f0f0;background-color:transparent"><font face=Calibri>ID1234567890</font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;border-bottom:#f0f0f0;background-color:transparent" align=right><font face=Calibri>0.5</font></td> <td class=xl63 style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;border-bottom:#f0f0f0;background-color:transparent" colspan=8><b><font style="font-size:10px" face=Verdana>Results for 2_Questions_Test_Export_As_Test_Show_Score_to_Students</font></b></td></tr></tbody></table></p>© 2009 Microsoft Corporation. All rights reserved.Mon, 10 Nov 2008 12:32:49 Z4822b804-6368-4ffe-a85f-2912b835f6d0http://social.msdn.microsoft.com/Forums/en-US/Offtopic/thread/4822b804-6368-4ffe-a85f-2912b835f6d0#4822b804-6368-4ffe-a85f-2912b835f6d0http://social.msdn.microsoft.com/Forums/en-US/Offtopic/thread/4822b804-6368-4ffe-a85f-2912b835f6d0#4822b804-6368-4ffe-a85f-2912b835f6d0drarushhttp://social.msdn.microsoft.com/Profile/en-US/?user=drarushSharePoint Discussion List e-mail Reciver Parser- event handler code sample SharePoint Discussion List e-mail Reciver Parser need to parse in-coming messages and place 4 data itmes in 4 columns in an excel file to auto-reply.  Can you dislplay sample code of such a parser? an event that receiving an e-mail will trigger automatically?<br><br>Following is the e-mail content:<br> <h2> <center>Results for 2_Questions_Test_Export_As_Test_Show_Score_to_Students</center></h2> <table> <tbody> <tr> <td><b>Student Name:</b></td> <td>First LastNmae</td></tr> <tr> <td><b>Student ID:</b></td> <td>ID1234567890</td></tr> <tr> <td><b>Score:</b></td> <td>1 / 2 points (50%)</td></tr></tbody></table> <p>Your test results have been sent to Dr. S. Rush at <a href="mailto:s.rushinek@miami.edu">s.rushinek@miami.edu</a>. At this time, you can quit your browser or link to another page.<br>Parse copy and paste into an excel spreadsheet:<br>A                B                        C                D<br> <table style="width:528pt;border-collapse:collapse" cellspacing=0 cellpadding=0 width=704 border=0> <colgroup> <col style="width:48pt" span=11 width=64> <tbody> <tr style="height:15pt" height=20> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;height:15pt;background-color:transparent" width=64 height=20><font face=Calibri><strong><em><u>1 Name</u></em></strong></font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64><font face=Calibri><strong><em><u>ID</u></em></strong></font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64><font face=Calibri><strong><em><u>Grade</u></em></strong></font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64><font face=Calibri><strong><em><u>Test</u></em></strong></font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;width:48pt;border-bottom:#f0f0f0;background-color:transparent" width=64></td></tr> <tr style="height:22.5pt" height=30> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;border-bottom:#f0f0f0;height:22.5pt;background-color:transparent" height=30><font face=Calibri>2 First LastName</font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;border-bottom:#f0f0f0;background-color:transparent"><font face=Calibri>ID1234567890</font></td> <td style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;border-bottom:#f0f0f0;background-color:transparent" align=right><font face=Calibri>0.5</font></td> <td class=xl63 style="border-right:#f0f0f0;border-top:#f0f0f0;border-left:#f0f0f0;border-bottom:#f0f0f0;background-color:transparent" colspan=8><b><font style="font-size:10px" face=Verdana>Results for 2_Questions_Test_Export_As_Test_Show_Score_to_Students</font></b></td></tr></tbody></table></p>Thu, 05 Jun 2008 15:23:43 Z2008-06-06T01:02:04Zhttp://social.msdn.microsoft.com/Forums/en-US/Offtopic/thread/4822b804-6368-4ffe-a85f-2912b835f6d0#884bfcf4-71d9-483d-a08e-8cc7d9590c46http://social.msdn.microsoft.com/Forums/en-US/Offtopic/thread/4822b804-6368-4ffe-a85f-2912b835f6d0#884bfcf4-71d9-483d-a08e-8cc7d9590c46sudarshans1http://social.msdn.microsoft.com/Profile/en-US/?user=sudarshans1SharePoint Discussion List e-mail Reciver Parser- event handler code sample  <p style="margin:0in 0in 0pt;line-height:normal"><span style="font-size:10pt;font-family:'Verdana','sans-serif'">Hello Drarush,</span> </p> <p style="background:white;margin:0in 0in 12pt;line-height:normal"><span style="font-size:7.5pt;color:#080808;font-family:'Verdana','sans-serif'"> </span> </p> <p style="background:white;margin:0in 0in 12pt;line-height:normal"><span style="font-size:10pt;color:#080808;font-family:'Verdana','sans-serif'">Thank you for your post!  I would suggest posting your question in one of the <font color="#0072bc">Microsoft TechNet</font> &gt; <font color="#0072bc">Forums Home</font> &gt; <font color="#0072bc">SharePoint Products and Technologies</font> &gt; <font color="#0072bc">SharePoint - Excel Services</font> located here:  <a href="http://social.technet.microsoft.com/Forums/en-US/sharepointexcel/threads/">http://social.technet.microsoft.com/Forums/en-US/sharepointexcel/threads/</a>.</span> </p> <p style="background:white;margin:0in 0in 12pt;line-height:normal"><span style="font-size:10pt;color:#080808;font-family:'Verdana','sans-serif'">Have a great day!</span> </p>Mon, 10 Nov 2008 12:32:43 Z2008-11-10T12:32:43Z