|
还有一问题等完善:如何去掉这个提示框?谢谢!
Function email()
On Error GoTo email_Err
Dim mailto As String '收件人
Dim mailto2 As String '抄送人
Dim mailto3 As String '匿名抄送人
Dim strTitle As String '主题名称
Dim strContents As String '消息文本
mailto = "aa@accxp.com"
mailto2 = "bb@estarsoft.com"
mailto3 = "cc@accessoft.com"
strTitle = "这是主题"
strContents = "这是消息文本"
'表tabSteel是数据库中的一个表
DoCmd.SendObject acTable, "TabSteel", "MicrosoftExcel(*.xls)", mailto, mailto2, mailto3, strTitle, strContents, False, ""
email_Exit:
Exit Function
email_Err:
MsgBox Error$
Resume email_Exit
End Function
|
|