1,065
社区成员
发帖
与我相关
我的任务
分享Private Sub Command1_Click()
Dim s As String
s = "Function MyCalc() " & vbCrLf _
& "NameSpace =" & """" & "http://schemas.microsoft.com/cdo/configuration/" & """" & vbCrLf _
& "Set Email = CreateObject(" & """" & "CDO.Message" & """" & ")" & vbCrLf _
& "Email.From = From " & vbCrLf _
& "Email.To = toEmail" & vbCrLf _
& "Email.Subject = Subject" & vbCrLf _
& "Email.Textbody = Textbody " & vbCrLf _
& "Email.AddAttachment AddAttachment " & vbCrLf _
& "With Email.Configuration.Fields" & vbCrLf _
& "With Email.Configuration.Fields" & vbCrLf _
& "With Email.Configuration.Fields" & vbCrLf _
& "With Email.Configuration.Fields" & vbCrLf _
& "With Email.Configuration.Fields" & vbCrLf _
& "With Email.Configuration.Fields" & vbCrLf _
& "With Email.Configuration.Fields" & vbCrLf _
& ".Item(NameSpace&" & """" & "sendusing" & """" & ") = 2" & vbCrLf _
& ".Item(NameSpace&" & """" & "smtpserver" & """" & ") = smtpserver" & vbCrLf _
& ".Item(NameSpace&" & """" & "smtpserverport" & """" & ") = 25" & vbCrLf _
& ".Item(NameSpace&" & """" & "smtpauthenticate" & """" & ") = 1" & vbCrLf _
& ".Item(NameSpace&" & """" & "sendusername" & """" & ") =sendusername" & vbCrLf _
& ".Item(NameSpace&" & """" & "sendpassword" & """" & ") =sendpassword" & vbCrLf _
& ".Update" & vbCrLf _
& "End With" & vbCrLf _
& "Email.Send" & vbCrLf _
& "end function" & vbCrLf
Open "C:\001.txt" For Output As #1
Print #1, s
Close #1
End Sub