CREATE PROCEDURE SendEmails_sp
AS
BEGIN
SET nocount OFF;
DECLARE @EmailAddress VARCHAR(50),
@FullName VARCHAR(50),
@EmailSubject VARCHAR(255),
@EmailBody VARCHAR(MAX),
@RC INT
SET @EmailSubject = 'TEST Email'
DECLARE crsEmailList CURSOR FOR
SELECT EmailAddress
FROM SomeTable
OPEN crsemaillist
FETCH NEXT FROM crsEmailList
INTO @EmailAddress
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @EmailBody = 'Your Email Body'
exec @RC = msdb.dbo.sp_send_dbmail @profile_name = @EmailProfile,
@recipients = @EmailAddress,
@body_format = 'HTML',
@subject=@EmailSubject,
@body=@EmailBody
FETCH NEXT FROM crsEmailList
INTO @EmailAddress
END
CLOSE crsemaillist
DEALLOCATE crsemaillist
END
AZMatt
Star
10620 Points
1892 Posts
Wont let me post SQL code
Jul 31, 2012 09:00 PM|LINK
I am trying to post a stored procedure, but am unable to. In one case, it cut off after a couple lines. The next time I tried, it just timed out.
http://forums.asp.net/t/1829463.aspx/1?Sending+automated+email+to+address+from+database
Matt
AZMatt
Star
10620 Points
1892 Posts
Re: Wont let me post SQL code
Jul 31, 2012 09:03 PM|LINK
I tried to post it on this thread, same results. The procedure is similar to the one I posted here last month...
http://forums.asp.net/t/1803460.aspx/1?Database+mail+bulk+email+issue
tmorton
All-Star
56341 Points
9684 Posts
ASPInsiders
Moderator
Re: Wont let me post SQL code
Aug 01, 2012 02:35 PM|LINK
Are you able to paste in the text without using the Insert Code tool?
ASP.NET/IIS.NET Website Manager, Neudesic
AZMatt
Star
10620 Points
1892 Posts
Re: Wont let me post SQL code
Aug 01, 2012 02:46 PM|LINK
CREATE PROCEDURE SendEmails_sp AS BEGIN SET nocount OFF; DECLARE @EmailAddress VARCHAR(50), @FullName VARCHAR(50), @EmailSubject VARCHAR(255), @EmailBody VARCHAR(MAX), @RC INT SET @EmailSubject = 'TEST Email' DECLARE crsEmailList CURSOR FOR SELECT EmailAddress FROM SomeTable OPEN crsemaillist FETCH NEXT FROM crsEmailList INTO @EmailAddress WHILE @@FETCH_STATUS = 0 BEGIN SELECT @EmailBody = 'Your Email Body' exec @RC = msdb.dbo.sp_send_dbmail @profile_name = @EmailProfile, @recipients = @EmailAddress, @body_format = 'HTML', @subject=@EmailSubject, @body=@EmailBody FETCH NEXT FROM crsEmailList INTO @EmailAddress END CLOSE crsemaillist DEALLOCATE crsemaillist ENDAZMatt
Star
10620 Points
1892 Posts
Re: Wont let me post SQL code
Aug 01, 2012 02:46 PM|LINK
Seems to be working today.