//select expired issues
number [] issues = selectPages("stateexpiry >< startOfDay()");
//Create HTML message for email
string body = "<p>The following pages are past the expiry date:</p>";
body += "<ul>";
//loop through each expired page
for(number i in issues) {
//add expired page to email HTML
body += "<li><a href=\"" + i.tinyLink + "\">" + i.title + "</a></li>";
}
//close out HTML
body += "</ul>";
string [] to = {"john.doe@email.com", "jane.doe@email.com"};
string [] cc = {"jack.doe@email.com", "jeff.doe@email.com"};
return
sendEmail("", to, cc, "These pages need your attention!", body); |