Share
Report
207Hi Experts,
I am working on the scenario to send a reminder mails to the users who is joined 3 months before from today and who is not completed mandatory trainings in our organization , for example : August month the reminder will send to April & May month new joiners (which is already available in excel file with month wise) .
Need to send different team , so i have to filter the table with Team name 'AMERICAS' first and check the status for the completion . if status is completed then those employee name should exclude and no need to send mail to them. same for 'APAC' and other teams.
Cannot able to filter multiple columns in Filter Query and getting invalid error.
Expected results for AMERICAS mail reminder :
1st 3 lines should add in the mail body.
Status is overdue for all the 3 users , so all the 3 manager gets mail reminder with the new joiner names.
Attached the sample mail which they are doing manually every month.
Please help to achieve this asap .
Thanks
DK
Categories:
I have the same question (0)
All responses (
Answers (
