ms-access - 如何在发送前检查.Attachment.Add "filename"是否成功

Question

我有一些代码可以创建邮件对象 (Outlook)、附加文件并发送它。

Dim mobjOutlook, mobjActiveExp, mobjNewMail As Object

'Create Outlook objects
Set mobjOutlook = CreateObject("Outlook.Application")
Set mobjActiveExp = mobjOutlook.ActiveExplorer
Set mobjNewMail = mobjOutlook.CreateItem(olMailItem)

'Setup and send email
With mobjNewMail
    .To = "someone@test.com"
    .Subject = "theSubject"
    .Body = "some text"
    .Attachments.Add "C:/The/File/Path.doc"
    '*I need to check here if the above line worked*
    .Send
End With

如何在发送前测试附件是否有效？这可能吗？出于某种原因，即使没有，它仍然会发送不带附件的电子邮件。

我正在考虑以某种方式利用“.Save”选项。

非常感谢任何想法或建议，谢谢。

Answer 1

您可以只测试电子邮件中的附件数量 > 0

还有

Dim mobjOutlook、mobjActiveExp、mobjNewMail 作为对象
会将前两个变量变暗为变体，所以我在下面重新剪切了它

Sub Test()
Dim mobjOutlook As Object
Dim mobjActiveExp As Object
Dim mobjNewMail As Object

'Create Outlook objects
Set mobjOutlook = CreateObject("Outlook.Application")
Set mobjActiveExp = mobjOutlook.ActiveExplorer
Set mobjNewMail = mobjOutlook.CreateItem(olMailItem)

'Setup and send email
With mobjNewMail
    .To = "someone@test.com"
    .Subject = "theSubject"
    .Body = "some text"
    .attachments.Add "C:\temp\step1.png"
    If .attachments.Count > 0 Then
        .Send
    Else
        MsgBox "No attachment", vbCritical
    End If
End With
End Sub