excel vba怎么实现 邮箱的定时发送邮件的功能?在哪里添加可以实现,outlook延时传递的功能
Submail()Application.ScreenUpdating=FalseOnErrorResumeNextDimTempAsObjectDimNewmailAs...
Sub mail()
Application.ScreenUpdating = False
On Error Resume Next
Dim Temp As Object
Dim Newmail As Object
Dim strg As String
Set Temp = CreateObject("outlook.application")
Set Newmail = Temp.CreateItem(0) '寻找默认的outlook
With Newmail
.Application.OnTime ("07:25:30")
.To = "1593976354@qq.com"
.DeferredDeliveryTime = 2014 / 9 / 30
.CC = ""
.Subject = "东方德发excel关键日期提醒"
.Body = "EXCEL发邮件" '
.Attachments.Add ("C:\Users\HOULEI\Desktop\dhdh\合同.xlsm")
.Send
End With
Set Temp = Nothing
Set Newmail = Nothing
Application.ScreenUpdating = True
End Sub
在哪里添加可以实现,outlook延时传递的功能 展开
Application.ScreenUpdating = False
On Error Resume Next
Dim Temp As Object
Dim Newmail As Object
Dim strg As String
Set Temp = CreateObject("outlook.application")
Set Newmail = Temp.CreateItem(0) '寻找默认的outlook
With Newmail
.Application.OnTime ("07:25:30")
.To = "1593976354@qq.com"
.DeferredDeliveryTime = 2014 / 9 / 30
.CC = ""
.Subject = "东方德发excel关键日期提醒"
.Body = "EXCEL发邮件" '
.Attachments.Add ("C:\Users\HOULEI\Desktop\dhdh\合同.xlsm")
.Send
End With
Set Temp = Nothing
Set Newmail = Nothing
Application.ScreenUpdating = True
End Sub
在哪里添加可以实现,outlook延时传递的功能 展开
3个回答
展开全部
我只知道怎么用QQ邮箱发送,OUTLOOK不知道是不是也适用
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
我有兴趣给你研究 已经私信你了
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询