Sql Server Email

[dotnetrockz]

[CODE]
Declare @MailDesc varchar(8000)
Declare @MailTo_1 varchar(1000)
Declare @MailCC_1 varchar(400)
Declare @body1 varchar(1000)
Declare @file_attachments nvarchar(1000)
Set @MailTo_1 = '[email protected]'

set @body1 = (Select [col]
From dbo.tbl_name Where col_id = 1)
Begin
exec msdb.dbo.sp_send_dbmail
@profile_name = 'MAIL',
@recipients = @MailTo_1,
--@copy_recipients = @MailCC_1,
@body = @body1,
@subject = 'Record',
@body_format = 'HTML'
end

[/CODE]

@Darling...nee code ni code format lo post chesthunna so its readable...

[netdevelooper]

yekkada admin leru and 600 different emails and matter same ye

[Darling999]

[quote name='netdevelooper' timestamp='1353344231' post='1302823279']
yekkada admin leru and 600 different emails and matter same ye
[/quote]
Painaa Nissan Cheppi Nattu, if you are sending same record to all 600 emails then create a Distribution Mail group and add it to the Parameter you need. DG List nuvvey creaste cehyyachu outlook lo anni mail Ids add cehyyi dantlo, google it once youll get an Idea

[Darling999]

[quote name='Nissan' timestamp='1353343997' post='1302823239']
[CODE]
Declare @MailDesc varchar(8000)
Declare @MailTo_1 varchar(1000)
Declare @MailCC_1 varchar(400)
Declare @body1 varchar(1000)
Declare @file_attachments nvarchar(1000)
Set @MailTo_1 = '[email protected]'

set @body1 = (Select [col]
From dbo.tbl_name Where col_id = 1)
Begin
exec msdb.dbo.sp_send_dbmail
@profile_name = 'MAIL',
@recipients = @MailTo_1,
--@copy_recipients = @MailCC_1,
@body = @body1,
@subject = 'Record',
@body_format = 'HTML'
end

[/CODE]

@Darling...nee code ni code format lo post chesthunna so its readable...
[/quote]

Thats a Better View Nissan. Thanks

[littlemoon]

[quote name='netdevelooper' timestamp='1353344231' post='1302823279']
yekkada admin leru and 600 different emails and matter same ye
[/quote]
distribution email group create cheyali...

[Darling999]

ikkada reply lu esetolley unnaru assalodu Maayam...[img]http://i1354.photobucket.com/albums/q681/mutamesthri/temp-300-81688885_zpse8930264.gif [/img]

[littlemoon]

[quote name='DARLING...' timestamp='1353345198' post='1302823448']
ikkada reply lu esetolley unnaru assalodu Maayam...
[/quote]
bayapetesaru meeru andaru syntax lu ichi

[netdevelooper]

nenu pm chesanu rek knchm check cheyara

[Darling999]

[quote name='littlemoon' timestamp='1353345397' post='1302823484']
bayapetesaru meeru andaru syntax lu ichi
[/quote]
Pilla vaadu line tappi atetoo veltuntey direct query ichi lopaliki rammanna, bhayapditey ela [img]http://oi52.tinypic.com/2posdq8.jpg[/img]

[Darling999]

[quote name='netdevelooper' timestamp='1353345583' post='1302823523']
nenu pm chesanu rek knchm check cheyara
[/quote]
nenu reply ichaa sooskoo