I would like to be able to send an email with different merge fields (are they called like that in MC?). So far, I've figured out how to merge the fields regarding the data extension from where the email template is feeding but, is there any way to be able to reference other data extensions, maybe through data relationships?

At the moment my template is something like this:

Dear %%LastName%%,
We would like to contact you on notice of your article %%Article_Title%%

Where Article_Title is in a different data extension.

I'm not even sure if this is the correct approach, so I'm open to other ones.

  • 1
    You'll want to use a lookup function. As long as the data extensions are connected (usually by a subscriber_key) you will be able to display fields from related tables. developer.salesforce.com/docs/… Oct 4 '17 at 19:44

It'll look something like this:
%%[SET @city = Lookup(“ShipAreas”,”City”,”Zip”,Zip)]%%
Then within the html you can call out your variable like this:

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.