如何启用Outlook 2013宏 [英] How to enable Outlook 2013 macros

问题描述

我有一个我在VBA写的宏 不到两年前在Outlook 2013中为我自动执行任务。 这个宏是用我为自己创建的数字证书签名的。 宏安全设置为数字签名宏的通知，
禁用所有其他宏。



直到几天前，我没有遇到任何问题。  ;然后，突然之间（至少，我不记得会引发我的问题的任何变化），Outlook 2013开始拒绝运行我的宏。 我收到以下消息：

I have a macro that I wrote in VBA  not quite two years ago to automate a task for me in Outlook 2013.  This macro was signed with a digital certificate I created for myself.  Macro security was set to Notifications for digitally signed macros, all other macros disabled.

Up until a few days ago, I was having no problems.  Then, out of the blue (at least, I cannot recall any change that would have triggered my problem), Outlook 2013 started refusing to run my macro.  I get the following message:

"此项目中的宏已被禁用。 请参阅主机应用程序的在线帮助或文档以确定如何启用宏。"我已经尝试了许多我在互联网上阅读的不同技巧，但几乎没有成功。 我已完全删除了VbaProject.OTM文件，并从个人商店和受信任的
发布商商店中删除了我从计算机创建的证书。  （顺便说一句，Outlook永远不会将我视为受信任的发布者：我无法将自己删除为本地帐户中的受信任发布者，但是以管理员权限运行Outlook并未将我显示为受信任的发布者
可以删除。我认为只有在我使用控制台（mmc.exe）从受信任的根证书存储中删除证书后，Outlook才最终停止将我显示为受信任的发布者。）



重新启动计算机后，我将代码粘贴到新创建的（通过Outlook）VbaProject.OTM文件中。 代码运行一次，我认为问题已经解决了。 然后我关闭并重新启动Outlook，问题再次出现。



无论是否使用新的自签名证书签署代码，我都尝试了上述方法。  它没有任何区别。 我第一次创建VbaProject.OTM文件时运行代码;下次Outlook启动时，我再次出现对话框。

"The macros in this project are disabled.  Please refer to the online help or documentation of the host application to determine how to enable macros."

I have tried many different tricks I have read about on the Internet, but with little to no success.  I have completely deleted the VbaProject.OTM file and removed the certificate I created from the computer, both from the Personal store and the Trusted Publishers store.  (Incidentally, it took forever for Outlook to not see me as a Trusted Publisher: I could not remove myself as a Trusted Publisher in the local account, but running Outlook with administrator privileges did not show me as a Trusted Publisher that could be removed.  I think it was only after I removed the certificate from the Trusted Root Certificate store using the Console (mmc.exe) that Outlook finally stopped showing me as a Trusted Publisher.)

After a reboot of the computer, I pasted by code into a newly created (by Outlook) VbaProject.OTM file.  The code ran once, and I thought the problem was solved.  I then shut down and restarted Outlook, and the problem reappeared.

I have tried the above approach both with and without signing the code with a new self-signed certificate.  It makes no difference.  The code runs when I first create the VbaProject.OTM file; the next time Outlook starts, I get the dialog box again.

如果我将宏安全性设置为启用所有宏，则宏将运行。 但我不希望禁用宏安全性：这是代码自我签名的重点。 由于每次更改
宏安全级别时都必须关闭并重新启动Outlook，因此启用所有宏来运行我的代码将非常耗时（我每天运行几次这样的宏）。 />


关于我的电脑的一些细节：

Windows 10家庭版，64位

Outlook 2013，Office的一部分2013年
该代码确实需要引用Microsoft Word 15.0对象库（虽然我看不出为什么会产生影响）。

The macro will run if I set the macro security to Enable all macros.  But I do not want to have the macro security disabled: that was the point in self-signing the code.  And since I have to shut down and restart Outlook each time I change the macro security level, enabling all macros just to run my code would be very time-consuming (I run this macro several times a day).

Some particulars about my computer:
Windows 10 Home edition, 64-bit
Outlook 2013, part of Office 2013
The code does require a reference to the Microsoft Word 15.0 Object Library (although I can't see why that would make a difference).

任何让Outlook让我的宏再次运行的帮助将不胜感激！

Any help in getting Outlook to let my macros run again would be greatly appreciated!

Ariel S. Rogson

Ariel S. Rogson

推荐答案

你好Ariel，

Hello Ariel,

看起来你需要从一个可靠的证书购买供应商，例如，

DigiCert 。

Looks like you need to purchase a certificate from a trusted vendor, for example, DigiCert .

这篇关于如何启用Outlook 2013宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！