select certificate, expirationDate, issuer, mainContact, emailContacts, notes, DATEDIFF(d,getdate(),expirationdate) as daystogo from fsenablers..tbl_fse_securecertificates where DATEDIFF(d,getdate(),expirationdate) <= minDaysAlert and active = 'Y' order by expirationdate

The certificate for #qryCertsAlerts.certificate# expires in #qryCertsAlerts.daystogo# days!

Certificate contact: #qryCertsAlerts.mainContact#

Notes: #qryCertsAlerts.notes#

This alert was sent to: #replace(qryCertsAlerts.emailContacts,",",", ","all")#

 select emailContacts from fsenablers..tbl_fse_securecertificates select certificate, expirationDate, issuer, mainContact, emailContacts, notes, DATEDIFF(d,getdate(),expirationdate) as daystogo from fsenablers..tbl_fse_securecertificates where active = 'Y' order by expirationdate
Domain Contact Expiration Days Left Notes
#qryCertsSummary.certificate# #qryCertsSummary.mainContact# #dateformat(qryCertsSummary.expirationDate,"mm/dd/yyyy")# #numberformat(qryCertsSummary.daystogo,"9,999")# #qryCertsSummary.notes#
#_emailcontent#

This email was sent to: #replace(_uniqueContacts,",",", ","all")#