Automatic Date Reminders

**fleee6** · 07-29-2013, 01:33 AM

Dear all, I am very new to this, so first off, hi everyone!

I have a spreadsheet with multiple client details and information, for which there is a "deadline" column, to indicate when payment is due to each client or vice versa. I wanted to see if it were possible to use VBA to create either a pop-up reminder or an email notification to remind me when this deadline has been reached, i.e. date=today. or something like that. I have seen similar posts on this in the forum, but have been unable to adapt the solutions to match my spreadsheet since I don't understand VBA that much at the moment.

Thanks in advance!

**Debraj Roy** · 07-29-2013, 02:08 AM

Hi fleee6,

It will be very helpful, if you can attached a sample workbook, with expected output.

or you can paste similar post's url, so that we can guess expected output..

**fleee6** · 07-31-2013, 07:09 PM

Hi, sorry it took me awhile to respond to this. Please find here a sample of the excel file i am working with. The deadline to be tracked is reflected in columns I, O and P. When the current month is August, for example, those that reflect as August in columns I, O and P, currently reflect as "URGENT" in columns M, R and T respectively. What I am hoping to achieve is that rather than this, which requires a manual checking of the spreadsheet, is for either a pop-up reminder to the effect of "Hi, cell B5, B6, B15 is due this month", or better yet, an email notification to the same effect to the company email. I hope this is clear. Please let me know if more information is required. And thank you so much for helping!