我有以下代码,但它无法正常工作 . 我对VBA也很新 . 该代码用于填充电子邮件模板,但是一旦我添加.Attachment.Add它就不起作用 .
Sub CreateMail()
Dim objOutlook As Object
Dim objMail As Object
Dim rngTo As Range
Dim rngSubject As Range
Dim rngBody As Range
Set objOutlook = CreateObject("Outlook.Application")
Set objMail = objOutlook.CreateItem(0)
With ActiveSheet
Set rngTo = .Range("E2")
Set rngSubject = .Range("E3")
Set rngBody = .Range("E4")
.Attachments.Add "Z:\PHS 340B\Letters of Non-Compliance\..Resources\W9 Form\VPNA W-9 01 09 2017"
End With
With objMail
.to = rngTo.Value
.Subject = rngSubject.Value
.Body = rngBody.Value
.Display 'Instead of .Display, you can use .Send to send the email _
or .Save to save a copy in the drafts folder
End With
Set objOutlook = Nothing
Set objMail = Nothing
Set rngTo = Nothing
Set rngSubject = Nothing
Set rngBody = Nothing
End Sub
2 回答
试试这个:
在Outlook而不是Excel中工作时,您需要使用.Attachments.Add .
这个简单的脚本应该说明如何向电子邮件添加附件,然后发送电子邮件 .
https://www.rondebruin.nl/win/s1/outlook/amail1.htm