I need some help with a line of AMPScript to enter into the
From Name and
From Email in the Sender Profile set up page. I am trying to build a dynamic sender profile that will look up a relationship manager ID for each recipient in the sendable data extension, look up that value in a reference data extension, and then return that corresponding value.
I have two Data Extensions:
- Sendable Data Extension - includes the subscriber info pulled from Sales Cloud, including an ID number for a relationship manager
- Reference Data Extension - includes a list of relationship manager IDs, their full names and email addresses
The sample line of AMPScript MC keeps pointing me to is the following.
Here is the specific example of the lookup function:
However, in the case above, its looking to match the zip provided
46016. In my case, I don't want to provide a definitive value in the script. I'm looking for the script to trigger a lookup based on the relationship manager ID that is specific to each subscriber.
Any help would be appreciated!