declare
  @isql varchar(2000),
  @email varchar(64)
  
  declare c1 cursor for select distinct email FROM DatabaseName.dbo.SomeTable WHERE CampaignID = 42 and dbo.IsValidEmail(email) = 1
  open c1
  fetch next from c1 into @email
  While @@fetch_status <> -1
    begin
declare @body1 varchar(4000)
set @body1 = 'Latest documentation For You. ' + CONVERT( VARCHAR( 20 ), GETDATE(), 113 ) + 
' '


EXEC msdb.dbo.sp_send_dbmail @recipients=@email,
    @subject = 'Latest documentation ',
    @body = @body1,
    @body_format = 'HTML',
    @file_attachments = 'c:\ServerAttachments\ERP.pdf'
    
    fetch next from c1 into @email
    end
  close c1
  deallocate c1