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 ?
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') ]%%