@wsm 发表于 2012-7-13 13:21
附件跟上,谢谢
Option Explicit
Sub 发送邮件()
On Error Resume Next
Dim objOutlook As Object
Dim objMail As Object
Set objOutlook = CreateObject("Outlook.Application") '建立一个新的OUTLOOK对象实例
Set objMail = objOutlook.CreateItem(0) '新建邮件项目
With objMail
' .To = "
XXXX@sin.com" '新邮件的接受人
.CC = "
YYYYYY@sin.com"
.Subject = "银行" '新邮件的主题
.Body = "这是一封测试邮件,用来测试邮件发送的程序。" '新邮件的正文
.Attachments.Add "d:\20110628
.xls" '新邮件的附件就是没有附件
后缀名
.Send '发送新邮件
End With
Set objMail = Nothing
Set objOutlook = Nothing
End Sub