我创建了一个包含日期（B2：B10）和时间（C2：C10）的2单元格。
我声明了单元格，这样它将根据单元格中的日期和时间发送电子邮件，但它显示自动化错误

Sub Send_Deferred_Mail_From_Excel()
    Dim OutlookApp As Object
    Dim OutlookMail As Object
    Dim cell As Range
    Set cell = Range("B2:C2")

    Set OutlookApp = CreateObject("Outlook.Application")
    Set OutlookMail = OutlookApp.CreateItem(0)

    'Send Email Using Excel VBA Macro Code
    With OutlookMail
        .To = "gaelvin@gmail.com"
        .CC = "nickjames@gmail.com"
        .BCC = ""
        .Subject = "Happy New Year"
        .Body = "Greeting Gael, Wish You a Very Happy New Year"
        
        'Send email on specific date & time
        .DeferredDeliveryTime = Range("B2:C2")
        
                
        .Display 'or just put .Send to directly send the mail instead of display
    End With

    Set OutlookMail = Nothing
    Set OutlookApp = Nothing
End Sub