Send mail IF condition is TRUE

Hi All,

I want to send mails IF the condition is TRUE.

Condition : Send mail before two weeks from review date.

Eg: IF review date is “01/08/2022”, I want to send mails before two weeks i.e on

FYI. Review date is available in excel.

Please help. Thanks in advance.


To get the date corresponding to 14 days before a reference date, use the AddDays method as in the example:

Hello @devanand.1292

If review date is 01/08/2022 you want to send an email of before two weeks. But I couldn’t understand what is the condition that you are trying to check here. Could you please elaborate more