Send reminder email 3 days before the date

Closed
katherina03 Posts 1 Registration date Friday July 21, 2017 Status Member Last seen July 21, 2017 - Updated on Jul 22, 2017 at 05:39 AM
Hello,

I'm new at this, any help will be appreciated.

I need excel to send automatic email 3 days before expiration date.

On my sheet theres 6 columns.
HOUSE NUMBER, CLIENT, AMOUNT, EXPIRATION DAY, REMARKS AND EMAIL.
Already when the date is 3 days before the date turns to read and in remarks 'send reminder appears'.
Now I need it to send automatically a reminder to the email address that his payment is due in 3 days.

Thank you in advance