send Reminder Email to Outlook if cell value reaching before due date
Hello Experts,
This is my first post in this site i hope it will be very useful to me.
i need to send reminder email to client through outlook, automatically if due date reaches before 30 days and 15 days in expiry date column " F & K" .
Each employee having two cards (Driving card and License card) if any one cards expiry soon before 30 and 15 days then send reminder email to the client and cc to others and date of email send to be register in column "H, I, M, N" of 15 and 30 days.
please refer the attachment for more information the original file and what result i need to be in outlook mail.
please Experts help me to solve this problems it will be very grateful and appreciate
|