We have a monthly newsletter for a product interest group. We would like to use a data extension to store email content (subject line, preheader, etc.) that can be used. Within the data extension there is a date field to mark when the email content was used, before the email is sent this field is left blank.
The email content DE has been set up as not sendable or testable. Can someone advise on how to use ampscript to ensure each row in the data extension is only used 1x. Each row contains email copy for 1 send.
To retrieve email content: This is what I was thinking...
%%[ var @subjectline, @preheader,
set @subjectline = Lookup("ContentDEName", "subjectline", "Date") set @preheader = Lookup("ContentDEName", "preheader", "Date",) ]%%
%%=v(@subjectline)=%%
%%=v(@preheader)=%%
To mark date used: