excel - Excel 中的 VBA 宏

Question

我试图通过使用下面的代码来提醒我自己的截止日期。在我运行后，它会向我发送电子邮件，用于所有达到日期的情况，但是当我设置另一个截止日期时，如果我不再次运行它就不起作用。请我需要一些帮助。

Option Explicit

Sub email()

    Dim r As Range
    Dim cell As Range
    Set r = Range("A361:A370")

    For Each cell In r

        If Date - cell.Value = 30 Then

            Dim Email_Subject, Email_Send_From, Email_Send_To, _
            Email_Cc, Email_Bcc, Email_Body As String
            Dim Mail_Object, Mail_Single As Variant

            Email_Subject = "Reminder"
            Email_Send_From = "[e-mail]"
            Email_Send_To = "[e-mail]"
            Email_Cc = ""
            Email_Bcc = ""
            Email_Body = "Please remind  "

            On Error GoTo debugs
            Set Mail_Object = CreateObject("Outlook.Application")
            Set Mail_Single = Mail_Object.CreateItem(0)
            With Mail_Single
            .Subject = Email_Subject
            .To = Email_Send_To
            .cc = Email_Cc
            .BCC = Email_Bcc
            .Body = Email_Body
            .send
            End With

        End If

    Next


    Exit Sub

debugs:
        If Err.Description <> "" Then MsgBox Err.Description
End Sub

标签： excelvba