从Excel发送邮件时运行Outlook宏 [英] Run Outlook Macro when sending mail from Excel

问题描述

我在Thisoutlooksession中有一个VBA代码，该代码在发送新邮件时运行.但是，当我使用Excel biltin选项发送邮件以发送附件时，Outlook中的代码无法运行.非常感谢您的帮助.

I have a VBA code in Thisoutlooksession that runs when new mail is sent. But when I send a mail using Excel biltin option to send the file attached, the code in the outlook don't run. Would appreciate youre help.

谢谢.

推荐答案

在这种情况下，某些Outlook功能没有被应用.

This is a situation where some Outlook functionality is not applied.

您使用另一个Microsoft Office应用程序(例如Microsoft Word，Microsoft Excel或Microsoft PowerPoint)中的代理发送"或其他发送"命令.当您使用命令将当前文件作为附件发送时，通常会发生这种情况.

"You use Send As or other Send commands from another Microsoft Office application, such as Microsoft Word, Microsoft Excel, or Microsoft PowerPoint. This scenario typically occurs when you use a command to send the current file as an attachment." Messages that are created outside Outlook do not include the default Outlook email signature

如果需要所有功能可用，则既需要从Outlook本身创建电子邮件，也需要从其他应用程序中以编程方式创建新电子邮件."

"If you need all features to be available, you either need to create the email from Outlook itself or create the new email programmatically from within that other application as well." Outlook UserForms dont work when emailing from another application

这是设计使然:由简单MAPI或mailto url创建和发送的消息不会触发OOM事件.这是有意为之-在这些情况下存在一些问题，因此事件被完全禁用." ItemSend事件未触发

"This is by design: messages created and sent by Simple MAPI or mailto url do not trigger OOM events. This is done on purpose - there were some problems in those scenarios, so events were completely disabled." ItemSend event is not firing

这篇关于从Excel发送邮件时运行Outlook宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！