/*
'******多个系统调用此存储过程
--CDS
--DOCC
--Rohs
--ISO
--Instrument Management System
--**********by Mouse
--**********2010-06-19
*/--(cSubject, sBody, Mail_To, Mail_cc, MailFrom, Fromname)
--EXEC proc ALL_Email 'test','This is Email','[email protected]','[email protected]','[email protected]', 'CDS Auoto Mail Send'CREATE PROCEDURE ALL_Email @cSubject varchar(50),
@sBody varchar(5000),
@Mail_To varchar(500),
@Mail_cc varchar(500),
@MailFrom varchar(80),
@Fromname varchar(50)AS
DECLARE @intRetCode INT
DECLARE @strErr1 VARCHAR(255)
DECLARE @strErr2 VARCHAR(255)
DECLARE @Object INTdeclare @outStr varchar(255)
/* 創建實例 */
EXECUTE @intRetCode = sp_OACreate 'ALL_Email.ISO',@Object OUTPUT--select @intRetCodeIF @intRetCode <> 0
BEGIN
/* 調用實例失敗 */
EXECUTE sp_OAgetErrorInfo @Object,@strErr1 OUT,@strErr2 OUT
PRINT '創建實例失敗,故障原因為:' + @strErr1 + ' ' + @strErr2
RETURN
END /* 創建成功,開始調用 */
EXECUTE @intRetCode = sp_OAMethod @Object,'Send_Email',@outStr OUT,@cSubject, @sBody, @Mail_To, @Mail_cc, @MailFrom, @Fromname IF @intRetCode <> 0
BEGIN
/* 調用方法出錯 */
EXECUTE sp_OAGetErrorInfo @Object,@strErr1 OUT,@strErr2 OUT
PRINT '調用方法失敗,故障原因是:' + @strErr1 + ' ' + @strErr2
EXECUTE sp_OADestroy @Object
RETURN
END
ELSE EXECUTE sp_OADestroy @Object
GO
'******多个系统调用此存储过程
--CDS
--DOCC
--Rohs
--ISO
--Instrument Management System
--**********by Mouse
--**********2010-06-19
*/--(cSubject, sBody, Mail_To, Mail_cc, MailFrom, Fromname)
--EXEC proc ALL_Email 'test','This is Email','[email protected]','[email protected]','[email protected]', 'CDS Auoto Mail Send'CREATE PROCEDURE ALL_Email @cSubject varchar(50),
@sBody varchar(5000),
@Mail_To varchar(500),
@Mail_cc varchar(500),
@MailFrom varchar(80),
@Fromname varchar(50)AS
DECLARE @intRetCode INT
DECLARE @strErr1 VARCHAR(255)
DECLARE @strErr2 VARCHAR(255)
DECLARE @Object INTdeclare @outStr varchar(255)
/* 創建實例 */
EXECUTE @intRetCode = sp_OACreate 'ALL_Email.ISO',@Object OUTPUT--select @intRetCodeIF @intRetCode <> 0
BEGIN
/* 調用實例失敗 */
EXECUTE sp_OAgetErrorInfo @Object,@strErr1 OUT,@strErr2 OUT
PRINT '創建實例失敗,故障原因為:' + @strErr1 + ' ' + @strErr2
RETURN
END /* 創建成功,開始調用 */
EXECUTE @intRetCode = sp_OAMethod @Object,'Send_Email',@outStr OUT,@cSubject, @sBody, @Mail_To, @Mail_cc, @MailFrom, @Fromname IF @intRetCode <> 0
BEGIN
/* 調用方法出錯 */
EXECUTE sp_OAGetErrorInfo @Object,@strErr1 OUT,@strErr2 OUT
PRINT '調用方法失敗,故障原因是:' + @strErr1 + ' ' + @strErr2
EXECUTE sp_OADestroy @Object
RETURN
END
ELSE EXECUTE sp_OADestroy @Object
GO
解决方案 »
- 求分时查询语句
- 大家看看这样的查询语句怎么写
- 如何在表的记录被update后设置ModifyTime(其中一字段)为记录的修改时间? 抢分啦
- 如何通过年月日统计某个年龄段的人数,高手请指教,谢谢!
- 请解释一条sql语句
- 请问创建表时,用上 ’DEFAULT 是 NOT NULL ,‘出错,如何才可以?
- 请问SQL2000启动依存WIN2000高级服务器版的哪些服务?
- 救急,Right Join 为何屡屡失效!!!
- 急急急!!!sql6.5数据库恢复问题
- 数据库中如何生成包含『默认值』和『描述』信息的SQL脚本?
- 关于bs架构订单及发货的处理
- SQL2000 中用SELECT 语句返回不重复记录。
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
--发送邮件模块
EXEC msdb.dbo.sp_sEND_dbmail
@profile_name='denghui_li',
@recipients=@mailto,
@copy_recipients=@mailcc,
@body =@html,
@subject =@title,
@body_format='html'
是发邮件组件吧!注册了吗!有权限启动吗?
什么提示?
可能 是邮箱的问题,换一个邮箱试一下,如163邮箱。
因为邮箱必须支持SMTP中转,检查一下!
謝謝各位我現在也只能先配置好Profile 再調用了。EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SendMail',
@recipients = @AddAddress,
@subject = @subjects,
@body = @mailbody,
@body_format = 'html'