如何使用 ASP.NET Outlook 附加组件在 SQL Server 中存储 Outlook 正文文本电话号码（或）选定区域？

Question

我在VS2010中使用Windows应用程序OutlookAddIn1(office-2007)，现在我的收件箱有一些邮件，每封邮件都有电话号码，现在我的任务是选择电话号码并单击鼠标右键，我将会出现保存文本或保存数字选项，然后选择该选项将该文本存储到 sql server2008 数据库表中，请帮助我的任何人了解该主题，请给出任何想法，这非常好紧急任务

谢谢 赫曼斯

Answer 1

 private void savenumbers()
        {
            try
            {
                Outlook.Application oApp;
                Outlook.Explorer oExp;
                Outlook.Selection oSel;
                object oItem;
                long i;
                // TODO: On Error GoTo Warning!!!: The statement is not translatable
                oApp = new Outlook.Application();
                oExp = oApp.ActiveExplorer();
                oSel = oExp.Selection;
                if ((oSel.Count == 0))
                {
                    System.Windows.Forms.MessageBox.Show("Nothing selected");
                    return;
                }
                for (i = 1; i <= oSel.Count; i++)
                {
                    oItem = oSel[i];

                    DisplayMessage(oItem);
                }
            }


            catch (System.Exception ex)
            {
                System.Windows.Forms.MessageBox.Show("Error " + ex.Message.ToString());
            }
        }
        public int outlooksavenumber(string testcopy)
        {

            int ReturnValue = 0;
            ReturnValue = SqlHelper.ExecuteNonQuery(LITRMSConnection, "usp_Outlooksavenumbers",
                                                                        new SqlParameter("@testcopy", testcopy));

            return ReturnValue;
        }

        void DisplayMessage(object oItem)
        {
            //Outlook.MailItem oMailItem;
            Outlook.MailItem oMail = (Outlook.MailItem)oItem;
            //System.Windows.Forms.MessageBox.Show(oMail.Subject);
            //System.Windows.Forms.MessageBox.Show(oMail.Body);
            string body = oMail.Body;
            Outlook.Inspector inspector = oMail.GetInspector;

            // Obtain the Word.Document object from the Inspector object
            Microsoft.Office.Interop.Word.Document document = (Microsoft.Office.Interop.Word.Document)inspector.WordEditor;

            // Copy the selected objects
            string testcopy = "";
            testcopy = document.Application.Selection.Text;

            outlooksavenumber(testcopy);
        }