如果主题包含字符串，如何显示msgbox

Question

以下Outlook宏完美工作，但是，我希望此MsgBox仅在主题为LIKE 'Fees Due%'或主题为LIKE' Status Change%'时才会显示。这可能吗？

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) 
    If MsgBox("Do you want to continue sending the mail?", vbOKCancel) <> vbOK Then 
     Cancel = True 
    End If 
End Sub 

Answer 1

应该

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) 
    Dim Subject As String 
    Subject = Item.Subject 

    If Subject Like "*Fees Due*" Or Subject Like "*Status Change*" Then 
     If MsgBox("Do you want to continue sending the mail?", _ 
        vbYesNo + vbQuestion + vbMsgBoxSetForeground, _ 
               "Check Subject") = vbNo Then 
      Cancel = True 
     End If 

    End If 
End Sub 

Answer 2

是。使用Like操作：

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) 
    If Item.Subject Like "Fees Due*" Or Item.Subject Like "Status Change*" Then 
     If MsgBox("Do you want to continue sending the mail?", vbOKCancel) <> vbOK Then 
      Cancel = True 
     End If 
    End If 
End Sub 

我加入外If ... End If，没有别的变化。