You're very welcome!

Hi Matt,

The problem has been solve.

Thank you very much. =)

Hi Arun,

A fix has been applied to your site. Would you mind checking and letting me know if the problem still occurs?

Thanks!

Hi Arun! There are no updates as of yet. Kindest Regards Burns

Hi Burns, Any update on this issue?

Hi Arun, After looking into this issue we have experienced similar problems when using other methods. We have pushed this to the Dev team and we will keep you updated as soon as we know more. Kind Regards Burns

Hi Burns, I check from the preview form trace, and I can see the loop stored procedure is returning the the different token for each rows.

Hi Arun, Thank you, this has helped us in furthering our investigation! Currently we have the Dev team looking into this but we would really appreciate it if you could help us investigate just a little deeper. We would like to rule out the Stored Procedure as a problem area. Can you confirm that the Stored procedure is returning the dynamic values you expect? To double check this i would build a string list of the access tokens within the function you are running so i can check the values from the data have refreshed on each loop. Thanks again! Burns

Hi, Below is the action to send the email ---------------------------------------------------------------------------------------------

// Get the list of employees who can recieve email token;
// Run Stored Procedure sp_GetRoleEmployees;
RolesId:= 6;
VarLocalEmployeesCSV:= RunStoredProcedure("sp_GetRoleEmployees","RolesId","2");	
	
VarLocalEmployeesCSVCount:= CSVGetListCount(VarLocalEmployeesCSV);
VarLocalEmployeesCSVCounter:= 0;
	
while:(VarLocalEmployeesCSVCounter< VarLocalEmployeesCSVCount) {
	PageId:= VarLocalInsertPageId; // id of the new row;
	EmployeeId:= CSVGetListItemByIndex(""&VarLocalEmployeesCSVCounter,VarLocalEmployeesCSV,",","|",0);
	EmailSendingTo:= CSVGetListItemByIndex(""&VarLocalEmployeesCSVCounter,VarLocalEmployeesCSV,",","|",4);
	
	// Run stored procedure to create and get token;
	VarToken:= RunStoredProcedure("sp_CreateNewToken","PageId,EmployeeId","2");
		
	// Send Email;
	SendHTMLEmail("Email Template",EmailSendingTo,"AttachmentDocument");
		
	//Increment counter;
	VarLocalEmployeesCSVCounter:= VarLocalEmployeesCSVCounter+ 1;
}

Hi Arun, Would you mind showing us the functions you are using in this process please. We have a few ideas in mind as to what may be happening for you but we need to know how you are processing the information. Many Thanks Burns