when we send mail from asp.net application,
if the no of recipent are large then it will give error like timeout.
you can send mail in sql server.
CREATE PROCEDURE [dbo].[sp_SendEmail] @ServerAddr varchar(80),
@FromAddr varchar(80),
@Recipient varchar(80),
@Subject varchar(132),
@BodyText varchar(2000),
@nRet int OUTPUT
AS
DECLARE @hr int
DECLARE @oSmtp int
EXEC @hr = sp_OACreate 'AOSMTP.Mail',@oSmtp OUT
EXEC @hr = sp_OASetProperty @oSmtp, 'RegisterKey', 'replace this text by your key'
EXEC @hr = sp_OASetProperty @oSmtp, 'ServerAddr', @ServerAddr
EXEC @hr = sp_OASetProperty @oSmtp, 'FromAddr', @FromAddr
EXEC @hr = sp_OAMethod @oSmtp, 'AddRecipient', NULL, @Recipient, @Recipient, 0
EXEC @hr = sp_OASetProperty @oSmtp, 'Subject', @Subject
EXEC @hr = sp_OASetProperty @oSmtp, 'BodyText', @BodyText
EXEC @hr = sp_OAMethod @oSmtp, 'SendMail', @nRet OUT
EXEC @hr = sp_OADestroy @oSmtp
refer these links
http://www.emailarchitect.net/WebApp/SMTPCOM/developers/sqlemail.asp
http://www.databasejournal.com/features/mssql/article.php/3489111 |