分享了好几年.....

刚又有人在找我.....

分享给大家,,

一个打包.压缩本地文件,,然后发邮件的.....- Dim account,password,email,topic,body,attachment '发邮件变量

  • Dim workpath,tempfolder,tempname,row,attachmentname '程序运行所需要临时变量
  • Dim logname,logpath,logcontent,logtime '日志变量
  • - '==================变量赋值开始=================================
  • account="1789633868@qq.com" '账号
  • password="118wanglei@2009" '密码
  • email="1789633868@qq.com" '收件人邮箱
  • topic=Date()&"-"&"RTX日志统计" '邮件主题
  • workpath="C:\q" 'RTX记录路径
  • '------获取附件变量-----------------------------------
  • - '------获取tempfolder-----
  • Set WshShell=Wscript.CreateObject("Wscript.Shell")
  • tempfolder=WshShell.SpecialFolders("MyDocuments") '临时路径可以自行指定
  • '-------------------------
  • logname="autoemail.txt"
  • tempname="temp.txt"
  • logpath=tempfolder&""&logname
  • '日志记录1------------
  • logtime=Now()
  • logcontent="======脚本运行开始======"&vbCrLf&"["&logtime&"]"&"---"&"开始获取附件路径"
  • WriteToFile logpath,logcontent
  • '日志记录1------------
  • row=getfilelist(workpath,tempfolder,tempname)
  • attachmentname=read(row,tempfolder,tempname)
  • If row=0 Then
  • attachment=""
  • logcontent="["&logtime&"]"&"---"&"获取附件路径失败"
  • body="此邮件为系统自动发送,附件为RTX每日统计!"&vbCrLf&"RTX日志为空,请确认!"
  • Else
  • attachment=workpath&""&attachmentname(row-2)
  • logcontent="["&logtime&"]"&"---"&"成功获取附件路径"
  • body="此邮件为系统自动发送,附件为RTX每日统计!"&vbCrLf&"详细记录请查看附件!"
  • end if
  • '日志记录2------------
  • logtime=Now()
  • WriteToFile logpath,logcontent
  • '日志记录2------------
  • '==================变量赋值结束=================================
  • - - '====================================运行主程序============================================
  • logtime=Now()
  • If Send_Mail(account,password,"1789633868@qq.com","",topic,body,attachment)=True Then
  • logcontent="["&logtime&"]"&"---"&"恭喜,成功发送邮件!"
  • Else
  • logcontent="["&logtime&"]"&"---"&"SORRY,网络故障导致发送邮件失败!"
  • End If
  • WriteToFile logpath,logcontent
  • deletefiles tempfolder,tempname
  • logcontent="======脚本运行结束======"
  • WriteToFile logpath,logcontent
  • '====================================运行主程序============================================
  • - - - '-============================函数==========================================================
  • - '================发送邮件函数=======================
  • Function Send_mail(You_Account,You_Password,Send_Email,Send_Email2,Send_Topic,Send_Body,Send_Attachment)
  • 'code by NetPatch
  • 'VBS发送邮件参数说明
  • 'You_Account:你的邮件帐号
  • 'You_Password:你的邮件密码
  • 'Send_Email: 主要邮件地址
  • 'Send_Email2: 备用邮件地址
  • 'Send_Topic: 邮件主题
  • 'Send_Body: 邮件内容
  • 'Send_Attachment:邮件附件
  • - You_ID=Split(You_Account, "@", -1, vbTextCompare)
  • '帐号和服务器分离
  • MS_Space = "http://schemas.microsoft.com/cdo/configuration/"
  • '这个是必须要的,不过可以放心的事,不会通过微软发送邮件
  • Set Email = CreateObject("CDO.Message")
  • Email.From = You_Account
  • '这个一定要和发送邮件的帐号一样
  • - Email.To = Send_Email '主要邮件地址
  • If Send_Email2 "" Then
  • Email.CC = Send_Email2 '备用邮件地址
  • End If
  • - Email.Subject = Send_Topic '邮件主题
  • Email.Textbody = Send_Body '邮件内容
  • - If Send_Attachment "" Then
  • Email.AddAttachment Send_Attachment '邮件附件
  • End If
  • - With Email.Configuration.Fields
  • .Item(MS_Space&"sendusing") = 2 '发信端口
  • .Item(MS_Space&"smtpserver") = "smtp."&You_ID(1) 'SMTP服务器地址
  • .Item(MS_Space&"smtpserverport") = 25 'SMTP服务器端口
  • .Item(MS_Space&"smtpauthenticate") = 1 'cdobasec
  • .Item(MS_Space&"sendusername") = You_ID(0) '你的邮件帐号
  • .Item(MS_Space&"sendpassword") = You_Password '你的邮件密码
  • .Update
  • End With
  • Email.Send
  • '发送邮件
  • Set Email=Nothing
  • '关闭组件
  • - Send_Mail=True
  • '如果没有任何错误信息,则表示发送成功,否则发送失败
  • If Err Then
  • Err.Clear
  • Send_Mail=False
  • End If
  • End Function
  • '=============获取文本文件总行数============================
  • Function getfilelist(filepath,getpath,getname)
  • Dim WshShell,command1,command2,getpathall
  • getfilelist=0
  • getpathall=getpath&""&getname
  • command1="cmd.exe /c dir "&Chr(34)&filepath&Chr(34)&" /a-d /o-d /b >"&Chr(34)&getpath&Chr(34)&""&getname&""
  • set WshShell = CreateObject("wscript.Shell")
  • WshShell.Run command1,0,True
  • Const ForReading = 1
  • Set objFSO = CreateObject("Scripting.FileSystemObject")
  • Set objTextFile = objFSO.OpenTextFile _
  • (getpathall, ForReading)
  • Do Until objTextFile.AtEndOfStream
  • strNextLine = objTextFile.Readline
  • getfilelist=getfilelist+1
  • Loop
  • objTextFile.Close
  • End Function
  • '=============读取文件内容到数组====================
  • Function read(readrow,readpath,readname)
  • Dim readpathall
  • readpathall=readpath&""&readname
  • If readrow复制代码