We want send to an email to two seperate data extensions at once (with dedupe), the email needs to pull data using AMPscript from those two data extensions.
We have tried using the Lookup() function, and this works well for one data extension but as soon as we try adding in the AMPScript for the second data extension it is unable to generate the email.
Our code is as below:
%%[ Var @subkey Set @subkey = _SubscriberKey Set @FPP1 = Lookup("PastWinnersRacing","FPP_RUNNER_NAME1","Subscriber Key",@subkey) Set @SFPP1 = Lookup("PastWinnersSport","PARTICIPANT1","Subscriber Key",@subkey) ]%%
Any help is appreciated, Cheers