将邮件从Outlook数据库存储到本地数据库-优快云博客

本文介绍了如何从Outlook Express数据库中获取邮件并存储到本地数据库中。首先，需要添加Outlook库的引用。接着，创建Windows应用程序，利用Form1类和按钮点击事件进行操作。邮件和附件分别存储在两个表中，邮件表的主键由fromID和Date组成。通过getOutlook()方法获取每个文件夹的邮件，然后将邮件数据和附件保存到数据库中，以便在网页或窗口应用中展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

大家好，

在这里，我将解释如何从Outlook Express数据库获取邮件并将其存储在我们自己的数据库中（本地）

最初，您必须从添加参考添加参考Outlook库10.0或11.0。

如果找不到，请从此处下载dll并安装。

点击这里

打开和Windows应用程序（或ASP.NET）

在Form1类代码（声明）中，

Microsoft.Office.Interop.Outlook.Application outlk = new Microsoft.Office.Interop.Outlook.ApplicationClass();
        MailItem t;
        string constr = "Data Source=.\\SQLEXPRESS;Initial Catalog=backstage;Integrated Security=True";
        SqlDataAdapter da = new SqlDataAdapter("select * from mail", "Data Source=.\\SQLEXPRESS;Initial Catalog=backstage;Integrated Security=True");
        SqlDataAdapter da2 = new SqlDataAdapter("select * from attachment", "Data Source=.\\SQLEXPRESS;Initial Catalog=backstage;Integrated Security=True");
        DataSet ds = new DataSet();
        DataSet ds2 = new DataSet();

然后，

在按钮中单击事件代码this，

private void button1_Click(object sender, EventArgs e)
        {
            getOutlook(); 
        }
        public void getOutlook()
        {
            SqlCommandBuilder cb = new SqlCommandBuilder(da);
            da.UpdateCommand = cb.GetUpdateCommand();
            SqlCommandBuilder cb2 = new SqlCommandBuilder(da2);
            da2.UpdateCommand = cb2.GetUpdateCommand();
            da.Fill(ds);
            da2.Fill(ds2);
            NameSpace NS = outlk.GetNamespace("MAPI");
            MAPIFolder inboxFld = NS.GetDefaultFolder(OlDefaultFolders.olFolderInbox);
            getFolderMail(inboxFld, "Inbox");
            MAPIFolder junkFld = NS.GetDefaultFolder(OlDefaultFolders.olFolderJunk);
            getFolderMail(junkFld, "Junk");
            MAPIFolder sentFld = NS.GetDefaultFolder(OlDefaultFolders.olFolderSentMail);
            getFolderMail(sentFld, "Sent");
            MAPIFolder outboxFld = NS.GetDefaultFolder(OlDefaultFolders.olFolderOutbox);
            getFolderMail(outboxFld, "Outbox");
            MAPIFolder draftFld = NS.GetDefaultFolder(OlDefaultFolders.olFolderDrafts);
            getFolderMail(draftFld, "Draft");
            MAPIFolder deleteFld = NS.GetDefaultFolder(OlDefaultFolders.olFolderDeletedItems);
            getFolderMail(deleteFld, "Delete"); 
        } 
public void getFolderMail(MAPIFolder folder, string foldername)
        { 
            int mailID = 0;
            for (int i = 1; i <= folder.Items.Count; i++)
            {
                try
                {
                    DataRow dr = ds.Tables[0].NewRow();
                    t = (MailItem)folder.Items[i]; 
                    int size = t.Size / 1000;
                    string sizeinK = size.ToString() + "K";
                    dr["folder"] = foldername;
                    dr["fromName"] = t.SenderName;
                    dr["fromID"] = t.SenderEmailAddress;
                    dr["toName"] = t.ReceivedByName;
                    dr["toID"] = t.To;
                    dr["cc"] = t.CC;
                    dr["bcc"] = t.BCC;
                    dr["subject"] = t.Subject;
                    dr["body"] = t.Body;
                    dr["date"] = t.SentOn ;
                    dr["attachment"] = t.Attachments.Count;
                    dr["size"] = sizeinK;
                    dr["readStatus"] = t.UnRead; 
                    ds.Tables [0].Rows.Add(dr);
                    da.Update(ds);
                    if (t.Attachments.Count > 0)
                    {
                        mailID = getMailID();
                        for (int j = 1; j <= t.Attachments.Count; j++)
                        {
                            DataRow dra = ds2.Tables[0].NewRow(); 
                            dra["mailID"] = mailID; 
                            dra["Name"] = t.Attachments[j].DisplayName;
                            string filePath =Path.GetDirectoryName(System.Windows.Forms.Application.StartupPath ) +t.Attachments[j].FileName;  // @"G:/prabu"
                            t.Attachments[j].SaveAsFile(filePath);
                            FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read);
                            int length = (int)fs.Length;
                            byte[] content = new byte[length];
                            fs.Read(content, 0, length);
                            dra["contents"] = content;
                            dra["contentSize"] = length; 
                            fs.Close();
                            FileInfo f = new FileInfo(filePath);
                            f.Delete();
                            ds2.Tables[0].Rows.Add(dra);
                            da2.Update(ds2);
                        }
                    }
                }
                catch (System .Exception  ex)
                {  
                } 
            }
        } 
 public int getMailID()
        {
            int mailID = 0;
            SqlDataAdapter da1 = new SqlDataAdapter("select max(mailID) as newMailID from mail", constr);
            DataSet ds1 = new DataSet();
            da1.Fill(ds1);
            foreach (DataRow dr in ds1.Tables[0].Rows)
            {
                mailID =Convert .ToInt32 ( dr["newMailID"]);
            }
            return mailID;
        }