0  416    21  21

Name	곽진석
Subject	SQL 에서 Object 사용 방법, 메일발송방법

CREATE PROCEDURE [dbo].[sp_send_cdontsmail]     @From varchar(100),     @To varchar(100),     @Subject varchar(100),     @Body char(8000),     @CC varchar(100) = null,     @BCC varchar(100) = null     AS     Declare @MailID int     Declare @hr int     EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT     EXEC @hr = sp_OASetProperty @MailID, 'From',@From     EXEC @hr = sp_OASetProperty @MailID, 'Body', @Body     EXEC @hr = sp_OASetProperty @MailID, 'Body', @Body     EXEC @hr = sp_OASetProperty @MailID, 'MailFormat', 0   EXEC @hr = sp_OASetProperty @MailID, 'BodyFormat ', 0   EXEC @hr = sp_OASetProperty @MailID, 'BCC',@BCC     EXEC @hr = sp_OASetProperty @MailID, 'CC', @CC     EXEC @hr = sp_OASetProperty @MailID, 'Subject', @Subject     EXEC @hr = sp_OASetProperty @MailID, 'To', @To     EXEC @hr = sp_OAMethod @MailID, 'Send', NULL     EXEC @hr = sp_OADestroy @MailID

Prev	로딩 페이지	곽진석

Next

Com+ 사용예제 (ASP)

곽진석

Copyright 1999-2025 Zeroboard / skin by JiYoo