[SalesForce] Personalization error: %%program_cd%%

I'm just trying to practice a simple Lookup function. I event looked at AMPscript lookup Examples. However I do not understand what is wrong with my AMPscript-code.

I'm getting this error below from SFMC:

Unable to generate preview

Personalization error: %%program_cd%%
To fix the problem, please try the following:
– Make sure that there is not a space or typo within the personalization string in your email. For example, check and correct any spaces between percent signs (%%)
– Correct the HTML Body of your email.

my code:

%%[
    var @offer, @lookupvalue
    set @lookupvalue = AttributeValue("BannerURL")
    set @offer = Lookup("DE", "Offer", "BannerURL", @lookupvalue)
]%%

%%=v(@offer)=%%

Best Answer

It seems like the error isn't in the AMPscript-code you provided, but rather in the rest of the email, which contains the invalid personalization string %%program_cd%%. This could be in any content block, template or even the header/footer configured in your sender profile.

Try a plain email without any template and if this doesn't work check your header/footer configuration for further debugging.

Related Solutions

[SalesForce] How to pass data to an email via a triggered send

Welcome to SFSE!

Do you have a maxTransport column in the target Data Extension configured in your Triggered Send Definition? If not, you'll need one.

It's a good practice to wrap personalization strings with the AttributeValue() function in your email. Make sure to include the double-quotes around the attribute name. For example:

%%[

var @maxTransport
set @maxTransport = AttributeValue("maxTransport")

]%%
<br>maxTransport: %%=v(@maxTransport)=%%

If you use the AttributeValue() function, you can check if it's undefined or empty using the empty() function, e.g:

%%[

if not empty (@maxTransport) then 
  outputLine(concat("maxTransport: ",@maxTransport))
else
  outputLine(concat("maxTransport is empty"))
endif

]%%

[SalesForce] Using Ampscript to call Salesforce Objects in Journey Builder

I had a look at the fields you provided and the discussion - I believe the following script should work, assuming the fields are the same.

%%[
    /* AMPscript pulls in the values associated with Salesforce Object triggering the send */
    /* Fields will be populated by trigger data. RecordId = Contact ID in SFDC */
    /* Contact:Id column is used to determine the rest of the information to look up the Loan Officer info */

    SET @OppId = [Opportunity:Id]
    SET @OwnerId = [Opportun‌ity:OwnerId]
    SET @ContactId = [Opportunity:Primary_Contact__c
    SET @FirstName = [Opportunity:Primary_Contact__‌r:FirstName]
    SET @EmailAddress = [Opportunity:Primary_‌Contact__r:Email]

    SET @OwnerRow = RetrieveSalesforceObjects("User", "NMLSNumber__c, FirstName, Name, Phone, MobilePhone, Fax, Email, Bio_Link__c", "Id","=",@OwnerId)
    IF RowCount(@OwnerRow) > 0 THEN 
      SET @NMLSnumber = Field(Row(@OwnerRow,1),"NMLSNumber__c")
      SET @LOFirstName = Field(Row(@OwnerRow,1),"FirstName")
      SET @LOFullName = Field(Row(@OwnerRow,1),"Name")
      SET @LODirect = Field(Row(@OwnerRow,1),"Phone")
      SET @LOMobile = Field(Row(@OwnerRow,1),"MobilePhone")
      IF Length(@LOMobile) > 10 THEN
       SET @LOMobile = Substring(@LOMobile,4,10)
      ENDIF
      SET @LOFax = Field(Row(@OwnerRow,1),"Fax")
      SET @LOEmail = Field(Row(@OwnerRow,1),"Email")
      SET @LOBioLink = Field(Row(@OwnerRow,1),"Bio_Link__c")
    ELSE

    ENDIF

  ]%%

Best Answer

Related Solutions

[SalesForce] How to pass data to an email via a triggered send

[SalesForce] Using Ampscript to call Salesforce Objects in Journey Builder

Related Topic