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.

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

1 Answer 1

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)
]%%
3
  • you are right, it works. what an error (facepalm)
    – fromero
    Commented Oct 25, 2019 at 9:33
  • 1
    no worries, happens to the best :-)
    – zuzannamj
    Commented Oct 25, 2019 at 9:34
  • One of the best helps offered here :) Commented Oct 25, 2019 at 12:18

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .