Right now I have this AMPScript which displays the First Name of the email recipient.
%%[ var @fname set @fname = [FirstName] ]%% %%[ var @fname set @fname = [FirstName] ]%% Dear %%[IF not empty(@fname) THEN]%%%%=v(@fname)=%%%%[ELSE]%%Member%%[ENDIF]%%
Since my data extension includes a primary key which is not email address. One email can be in multiple rows with a different name. How can I make sure ampscript does not pickup an older record where name is different but recipient email is same? In my case, I want ampscript to display first name from the record where
@EmailSend_Status == false. How can I do that?