How can we personalize the emails when sending to Salesforce Report or Campaign? How do we use personalization strings with data from Salesforce as Reports and Campaigns? or should we directly use AMPscript ?
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
Only fields that you have already configured and mapped in your Field Mapping will be available.
Your other three options are:
LookupRows('ZipCode','City',HomeCity) %%[ var @rs Set @rs= RetrieveSalesforceObjects('Lead', 'Id, FirstName,LastName', 'region', '=', 'west','AnnualRevenue', '>', '1000000') ]%%