Avatar

Level 4

Hi Team, 

 

i am just loading a file and sending emails to the emails which are there in the file loaded and the people which are there in file i am not importing them to recipient schema i am just using the target mapping as external and sending emails. 

 

But while sending the emails i will have to pass a link to each profile based on the values loaded from excel. 

Sample file which i loaded: 

Ramaswami_0-1595444080706.png

 

So in the email there will be a unique link and we need to pass the first letter of the job category in that link. In the above case i need to pass 'C' to the link. 

 

I am writing two personalization blocks : 

 

Block1 internal name : prdVIEW10011

 

<%

if(dataSource.Job_Category=='Corporate') {

%>https://XXXXXXXX/en-US?type=1&jobCat=<%@ include view='prdVIEW10015' %> <%

} else if(dataSource.Job_Category=='Call Center'){

%> https://XXXXXXX/en-US?type=2&jobCat=<%@ include view='prdVIEW10015' %> <%

} else if(dataSource.Job_Category=='test'){

%> https://XXXXXX/en-US?type=3&jobCat=<%@ include view='prdVIEW10015' %> <%

} else {

%> https://XXXXX/en-US?type=0&jobCat=<%@ include view='prdVIEW10015' %> <%

}

Block 2 (prdVIEW10015which i am using in block 1 : 

 

<% if ( dataSource.Job_Category != '' ) { %>
<%=dataSource.Job_Category[0]%>
<% } %>

i am using block 1 in email delivery : 

 

Ramaswami_0-1595444494177.png

 

 

The link should be like : https://XXXXX/en-US?type=0&jobCat=C

and i am getting link this : https://XXXXX/en-US?type=0