I'm having trouble with the ampscript LookupRows to grab data from a synchronized data extension. Here is what I have so far:
%%[ var @rows, @row, @first set @rows = LookupRows("Contacts","FirstName", @first) set @row = Row(@rows, 1) ]%% %%=ProperCase(@first)=%%
In this case I'd like to display the First Name which exists in the Contacts synchronized data extension but I am missing a piece of the puzzle. Any advice?