AMPScript for Dynamic Sender Profile not firing

Question

I’m trying to write a short Lookup script for a Dynamic Sender Profile and I’m struggling with it.

I have an email that I want to send to the members of a Data Extension, and I want the email come from the Account Executive assigned to each member of that Data Extension.

Here’s the script I’ve written and I’ll describe what I wrote and why I wrote it the way I did:

%%SET @email = Lookup(‘User.Copy’, ‘Email’, ‘Name’, ‘%%Account Executive%%’)%%

@email is the variable I’m setting. I want this to be the Account Executive’s email address, and it will populate in the From Email field of the Dynamic Sender Profile.

User.Copy - This is the Data Extension that contains the Account Executive’s email address.

Email - This is the column name in the User.Copy Data Extension that contains the Account Executive’s Email Address

Name - This is the column name in the Data Extension that I want to match on. I’m passing in the name of the Account Executive, and want to return the email of the Account Executive.

%%Account Executive%% - This is the name of the Account Executive. It’s coming from the Data Extension that contains the subscribers I want to send the email to.

When I send a test email, the AMPscript doesn’t fire. It just populates the AMPscript in the From Email of the email, and doesn’t populate the Account Executive’s email address. When I click Reply on the email, the Reply-To email address reverts to our Default Reply-To email address.

Any advice or troubleshooting you can offer on the script above?

Answer 1

Aside from not using curly quotes, you'll need to use an AMPscript block and then use inline notation for the output.

You can't mix AMPScript blocks and inline code, you'll need to reference your personalization string differently. AttributeValue will return an empty string if Account Executive doesn't exist in your send context.

%%[

var @email
set @email = Lookup("User.Copy", "Email", "Name", AttributeValue("Account Executive"))

]%%
%%=v(@email)=%%