Hello All,
I have excel in which have list of name based on date , alteryx need to filter current month and if there is any entry then it should send mail to that user and in the subject it should copy table as per below format
eg : if Alex name is available in current month then
To : alex21@css.com
Body :
Hello Alex,
Pls find all month data
Date | Name | Country | ||
Apr-22 | Alex | China | alex21@css.com | |
May-22 | Alex | China | alex21@css.com | |
Jun-22 | Alex | China | alex21@css.com | |
Jul-22 | Alex | China | alex21@css.com | |
Aug-22 | Alex | China | alex21@css.com | |
Sep-22 | Alex | China | alex21@css.com |
If user doesn't comes in current month then skip and proceed with other user
Solved! Go to Solution.
@adarsh2608 attached is an example of how this can be accomplished. I hope this is helpful for you!