How to Get Data of Particular Column in Email Template Subject

[Samujjal_Ghosh]

Hello,

I have a report with Week Number as a column where all the data in the week column is same.

I want to add that data to the subject of the email 

Example:  Deactivation File for Week 34

(where 34 is the week number)

[Raghu]

@Samujjal_Ghosh  can you share email template body

[Samujjal_Ghosh]

Email subject -
Fichier desactivation des comptes de la semaine {week number to be calculated based on 7 days in the past}

Email body -
Please find attached the weekly report for terminated users in France for the previous week.
This report was generated by Saviynt Prod instance on (today's date/time).

Thank you

[rushikeshvartak · Accepted solution]

Use below code 

Rushi Deactivation File for Week ${Calendar.getInstance().get(Calendar.WEEK_OF_YEAR)} Java