SELECT * FROM ContentManager WHERE ContentID = 'eBlastArchive' Food & Culinary Professionals

#GetContent.Title#

#GetContent.Content#
SELECT Distinct Month(Sent) as eBlastMonth, YEAR(Sent) as eBlastYear FROM eBlast_Sent WHERE Last_Published IS NOT NULL ORDER BY eBlastYear DESC, eBlastMonth DESC

#MonthAsString(eBlastMonth)# #eBlastYear#


SELECT * FROM eBlast_Sent INNER JOIN eBlast ON eBlast_Sent.eBlast_ID = eBlast.eBlast_ID WHERE Last_Published Is Not Null AND Month(Sent) = #eBlastMonth# AND Year(Sent) = #eBlastYear# ORDER BY Sent DESC

#Subject#
Sent #DateFormat(Sent, "mmmm dd, yyyy")#