I'm having a tough time setting up a dynamic sender profile for just the sender name. I have 3 different data extensions needed to pull the information together.
"CLM Call Data Filtered" is the data extension I am sending to. The attribute "mdmid" relates to my subscribers.
"BR_Call" is a non-sendable data extension that holds key pieces of data; "Territory_vod__c" and "External_id_vod__c" (this is the same as mdmid).
"TerritoryVOD" is a non-sendable data extension that holds the list of Sales Reps with a code for the territory; "Territory_vod__c" (same as the attribute in "BR_Call") and "SalesRep"
What I am trying to do is send to the "CLM Call Data Filtered" data extension, but have the "SalesRep" filed appear in the sender name in my dynamic sender profile. Below is what i've tried with the dynamic sender profile and have run into issues.
%%[var @Territory set @Territory = Lookup('BR_Call','Territory_vod__c','External_Id_vod__c','@mdmid') var @SalesRep set @SalesRep = Lookup('TerritoryVOD','SalesRep','Territory__vodc__c',@Territory)]%% %%=v(@SalesRep)=%%
sfmc doesn't give me an error message with this, but when I preview and test send the email it is never able to send it. I check in the tracking for test sends and it shows the test send with 0 sends.
"TerritoryVOD" can be linked to "BR_Call" through the common Territory_vod__c field. and "BR_Call" can be linked to "CLM Call Data Filtered" through the common "mdmid/External_id_vod__c" fields.
Any help is greatly appreciated.