如何将电子邮件从SQL取回Outlook. [英] How to get back emails from SQL to Outlook.

问题描述

大家好，

我有一种情况，我的所有特殊要求都是将所有Outlook电子邮件保存到SQL Server 2005.

I have a scenario, I'm saving all my outlook emails to SQL Server 2005 as a specific requirement of mine.

现在我需要的是将这些电子邮件从SQL Server同步回Outlook，可能是在某些按钮事件下进行的

Now what i need is to sync back those emails from SQL Server to Outlook, probably on some button event,

但是当我尝试将这些电子邮件发送到Outlook时，我认为这些邮件是Outlook的新电子邮件，

but when i try to send those emails to outlook, these are considered to be new emails by outlook, i need to

知道有什么方法可以将接收日期设置为以前的某个日期.

know is there any way that i can set the received date to some previous date.

在这方面请告诉我.

乌斯曼

 

推荐答案

我认为最简单的方法是将另一列作为'binary blob'添加到数据库表中并保存整个电子邮件(作为文件转换为MemoryStream)进入此单元格.当您需要将其重新导入时，只需从二进制二进制文件"单元中将其导出并保存 作为文件或直接导入Outlook.然后将保留所有字段.

I think the easiest way will be add another column to database table as 'binary blob' and save the whole email (as file converted to MemoryStream) into this cell. The when you need to import it back you just export it from 'binary blob' cell and save as file or directly import in Outlook. Then all fields will be preserved.

 

只有我的.2美分

这篇关于如何将电子邮件从SQL取回Outlook.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！