zencart Notice: FAILED to send Email to all recipients. tool->send email

Notice: FAILED to send Email to all recipients error while sending mail from admin>tools>sendmail option
If you want to fix the matter and have the subscribe addon then just check

email option - php
change admin/mail.php page
replace at line:27 do this
$smQuery=$audience_select['query_string'];code
$mail = $db->Execute($audience_select['query_string']);
if($mail->EOF){
$smQuery=str_replace('left','right',$smQuery);
$smQuery=str_replace('and (s.confirmed = 1 or s.customers_id >= 1)','',$smQuery);
$smQuery=str_replace('s.email_address','c.customers_email_address',$smQuery);
$smQuery=str_replace('where email_address','where customers_email_address',$smQuery);
$mail = $db->Execute($smQuery);
}

Problem i encountered is customer not in subscriber were not receiving mail rather what i found is basic query formation error in subscribe addon. Above is my fix.
Hope will help.