如何在SQL Server中存储发送电子邮件FROM OUTLOOK [英] how to store the sending email FROM OUTLOOK in the sql server

问题描述

如何在Sql Server中存储来自Outlook的发送邮件。我希望电子邮件和正文存储在Sql Server中。

How to store the sending email from Outlook in the Sql Server. I want email and body to be stored in Sql Server.

推荐答案

嗨;



你可以连接到smtp服务器，你得到发送框。



见这个



或者如果你有用户可以使用outlook库

Hi;

you can connect to the smtp server and you get the send box.

see this

or you can use the outlook library if you user have it

     OutLook.Application oApp = new OutLook.Application();
     OutLook.NameSpace oNS = (OutLook.NameSpace)oApp.GetNamespace("MAPI");
     oNS.Logon(Missing.Value, Missing.Value, false, true);

     foreach (OutLook.MAPIFolder folder in oNS.Folders)
     {
         string folderName = folder.Name;

         GetFolders(folder);

     }



public void GetFolders(MAPIFolder folder)
 {
     if (folder.Folders.Count == 0)
     {
         string path = folder.FullFolderPath;


         if (foldersTocheck.Contains(path))
         {
             //GET EMAILS.....
             foreach (OutLook.MailItem item in folder.Items)
             {
                 Console.WriteLine(item.SenderEmailAddress + " " + item.Subject + "\n" + item.Body);


             }
         }
     }
     else
     {
         foreach (MAPIFolder subFolder in folder.Folders)
         {
             GetFolders(subFolder);
         }
     }
 }

祝你好运



jeremy

good luck

jeremy

这篇关于如何在SQL Server中存储发送电子邮件FROM OUTLOOK的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！