0

I've added a Lookup in my email to retrieve the language of the customer but, despite there is data, the function doesn't retrieve anything (I tried with different values or Data Extensions but with the same result).

%%[ 
VAR @SubKey, @EmailAddress, @language

SET @EmailAddress = emailaddr 
SET @SubKey = _subscriberkey
SET @language = Lookup("Account_Salesforce","Language__pc","PersonContactId",@skey)
]%%

I tried performing a real email sent instead of the test and preview but no success either.

  • Tried adding the ent. prefix: "ent.Account_Salesforce"? – zuzannamj Oct 25 at 9:17
  • I tried it too but nothing. There is only one Business Unit in the account – fromero Oct 25 at 9:19
2

OK, I found it. You have set a @SubKey, while in the function you used @skey. Try this:

%%[ 
VAR @SubKey, @EmailAddress, @language

SET @EmailAddress = emailaddr 
SET @SubKey = _subscriberkey
SET @language = Lookup("Account_Salesforce","Language__pc","PersonContactId",@SubKey)
]%%
  • you are right, it works. what an error (facepalm) – fromero Oct 25 at 9:33
  • 1
    no worries, happens to the best :-) – zuzannamj Oct 25 at 9:34
  • One of the best helps offered here :) – Johannes Schapdick Oct 25 at 12:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.