我正在尝试运行宏以通过Outlook发送电子邮件。
我的代码如下所示:
Sub Mail_small_Text_Outlook()
'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
'Working in Office 2000-2013
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
strbody = "Hi there" & vbNewLine & vbNewLine & _
"This is line 1" & vbNewLine & _
"This is line 2" & vbNewLine & _
"This is line 3" & vbNewLine & _
"This is line 4"
On Error Resume Next
With OutMail
.To = "ron@debruin.nl"
.CC = ""
.BCC = ""
.Subject = "This is the Subject line"
.Body = strbody
'You can add a file like this
'.Attachments.Add ("C:\test.txt")
.Send 'or use .Display
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
在以下行:Set OutApp = CreateObject("Outlook.Application")
,则会给出错误:
runtime error '429': ActiveX Component can't create object.
我在cmd中运行了这一行:
regsvr32 /i "c:\windows\system32\outlvba.dll".
然后它给我这个错误:
The module "c:\windows\system32\outlvba.dll" failed to load.
Make sure the binary is stored at the specified path or debug it to check
for problems with the binary or dependent .DLL files. The specified
module could not be found.
需要一些指导。
1条答案
按热度按时间n53p2ov01#
您是否在有问题的PC上安装了Office的Click2Run版本?
Office 2010的Click2Run版本不支持自动化。有关详细信息,请参阅Office 2010 Click-to-Run compatibility with add-ins。您还可以找到How to: Verify Whether Outlook Is a Click-to-Run Application on a Computer文章。
有关详细信息,请参见You receive run-time error 429 when you automate Office applications。