使用脚本在 Outlook 中处理基于规则的电子邮件 [英] rule based email handling in outlook using scripts

问题描述

我有大约 8 组不同的电子邮件 ID 组，它们在我的 Outlook 客户端中被分配了一个特定的类别.所有电子邮件 ID 都存在于 SQL Server 数据库实例的表中，可以根据它们所属的类别获取.

I’ve about 8 different set of email id groups, which are assigned a particular category in my outlook client. All email id’s exists in a table in a SQL server database instance and can be fetched according to categories they belong to.

现在我希望将收到的邮件标记为一个类别，并自动将该邮件转发到使用数据库中的脚本获取的电子邮件 ID.

Now I wish to mark an incoming mail to a category and auto forward that mail to the email id’s fetched using a script from the database.

第一个问题 - 是否可以编写脚本并将其附加到规则?

First question - is it possible to write a script and attach it to a rule?

第二个问题 - 是否有必要让 Outlook 客户端始终开启以保持该系统的活动?我的意思是这个基于脚本的规则系统是作为服务器规则还是作为客户端规则工作?

Second question - Is it necessary to have a outlook client always on to keep this system alive? I mean will this script based rule system work as a server rule or just a client rule?

推荐答案

您可以将 VBA 宏附加到邮件规则.如下所示:

You can attach a VBA macro to a mail rule. It looks as follows:

Sub MyMessageRule(newMail As Outlook.mailItem)
....
End Sub

可以在此宏中使用 SQL 服务器数据库连接.

It would be possible to use a SQL server DB connection in this macro.

也可以使用服务器端脚本.但这需要访问权限和更多技能.

It is also possible to use server-side scripting. But that requires access rights and more skills.

这篇关于使用脚本在 Outlook 中处理基于规则的电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！