我有一个通过VBA创建电子邮件的函数。
我是通过Excel 2016完成的。当一些同事尝试使用它时,会出现缺少引用(Outlook Library 16.0)的错误。
我在网上寻找解决方案,并发现最好的方法是使用Late Binding。我已经阅读了相关信息,但不理解如何在以下示例代码中使其工作。
Sub EscalateCase(what_address As String, subject_line As String, email_body As String)
Dim olApp As Outlook.Application
Set olApp = CreateObject("Outlook.Application")
Dim olMail As Outlook.MailItem
Set olMail = olApp.CreateItem(olMailItem)
olMail.To = what_address
olMail.Subject = subject_line
olMail.BodyFormat = olFormatHTML
olMail.HTMLBody = email_body
olMail.Send
End Sub
Dim olApp As Outlook.Application
更改为Dim olApp As Object
。 - CallumDA