Hello,
I have spreadsheet that calculates whether a list of people's dates have expired (please see attached spreadsheet). It has the recipient's email, expiry date and status.
I would like to automatically put a reminder in that recipient's outlook calendar if their status is 'out of date' or 'due in 2 months'.
I am ok with the calculation within excel but would like some vba that sends the reminder.
Could somebody help.
Thankyou!
Bookmarks