I am trying to create a dynamic sender profile, but only change the sender name based on the sales rep associated to the record.
I essentially have 3 tables I need to work with. The sending data extension, which has UserID and EmailAddress.
The data extension with the connecting data, has Territory and UserID
And my Sales Reps data extension data with, SalesRepName and Territory
So I am needing to connect my sending data extension to my Sales Reps data extension and pull the sales reps name associated with the territory of my subscriber.
I was trying to use the lookup function with AMPscript in an email first to see if I can get it to generate a value, but every time I use it it just shows up blank.
%%[ var @Territory, @SalesRep, @UserID set @UserId = "%%UserID%%" set @Territory = Lookup("BR_Call","Territory_vod__c","UserID","@UserID") set @SalesRep = Lookup("TerritoryVOD","SalesRep","UserID","UserID") ]%% <br> <br> %%=v(@Territory)=%% <br> <br> %%=v(@SalesRep)=%%