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?