Need AMPScript to create Dynamic Sender Profile

Question

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: %%=Lookup("PostalCode","City","PostalCode",46016)=%%

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!

Answer 1

You'll need to reference the Relationship Manager ID in your lookup.

I'd approach it something like this. The AttributeValue() function handles null values gracefully.

%%[
var @rmId, @fromName, @fromEmail

/* set the var from the sending DE */
set @rmId = AttributeValue("RelationshipManagerID") 

/* retrieve fromName using @rmId */
set @fromName = lookup("ReferenceDE","fromName","RelationshipManagerID", @rmId) 

/* retrieve fromEmail using @rmId */ 
set @fromEmail = lookup("ReferenceDE","fromEmail","RelationshipManagerID", @rmId)

/* handle if no matching row was found */
set @fromName = iif(empty(@fromName),"Default From Name",@fromName)
set @fromEmail = iif(empty(@fromEmail),"[email protected]",@fromEmail)
    
]%%

Then in your Dynamic Sender Profile you'd reference the @fromName and @fromEmail like this.

From Name: %%=v(@fromName)=%%

From Email: %%=v(@fromEmail)=%%

UPDATE - 2018-03-22

Yeah, this doesn't work properly since the sender profile is processed by the OMM before everything else. This excellent answer outlines the proper solution:

1. Create a content box and set an External Key e.g. SenderEmail

2. Create a content box and set an External Key e.g. SendName

3. Inside your Content Boxes add your ampscript to set Email Name, Email address - though could be done as a simple Set @FromName = 'something' or you could also do a lookup to a data extension.

4. In you sender profile, add the following to your From Name / From Email boxes %%=ContentAreaByKey("SenderEmail")=%%

Answer 2

We can also achieve this by populating substitution strings in the sender profile for the profile attributes containing sender's details. Please correct me if this is wrong.