Send Email according to the date in the Excel sheet

Help Studio
1

Hello everyone,
I have a task to send email to the employees about notifications of the expiry date of their licence. I have an excel sheet containg the full names of the employee, their email adresses, expiry dates of the licence. So based on these informations I have to schedule sending emails. For example the expiry date one of the employee is 28.03.2023 and I need to send email 4 days before the expiration date which is 24.03.2023. And other employee has expiration date of 20.01.2023 so I need to send email 16.01.2023, 4 days before. Since in the Excel sheet I have 200 rows containg information about the 200 employee and they have different expiration dates and have different specific dates to send email such as 16.01.2023 and 24.03.2023. Is it possible to schedule sending emails according to the date condition? If yes how it’s possible? Can you suggest me or send some examples and ways how to solve it?

2

Hi @Symbat_Almakhan
Your use case is possible via the UiPath integration service.

Steps:

  1. Create a email connection and trigger the bot daily in UiPath integration service.
  2. Read the excel data and filter it with the current/today date during the process.
  3. Send an email

UiPath Integration service reference Link:

Regards,
Kaviyarasu N