automtic email notification

Can someone please help, I have attached an example. Basically what i am wanting to do is insert a macro that will check all of the cells in column AE and if any cell is empty on the date in the same row of that cell in column AF than a email is sent notifying me and copying someone else.Book2.xlsx

is there anyone who could please help me with this?

jmatthews, I can't help you with athe code you want, but someone from this forum I think it was john55 (apologies if it was someone else) post this link to some very useful codes about emailing
http://www.rondebruin.nl/sendmail.htm
I do use a very succesful auto email code which sends out a message when a date in a certain cell is reached or has past which you or someone else might be able to adapt for your needs, If you want it I'll post it Good Luck

jmatthews, I can't help you with athe code you want, but someone from this forum I think it was john55 (apologies if it was someone else) post this link to some very useful codes about emailing
http://www.rondebruin.nl/sendmail.htm
I do use a very succesful auto email code which sends out a message when a date in a certain cell is reached or has past which you or someone else might be able to adapt for your needs, If you want it I'll post it Good Luck

nje,
Thank you very much. If you could post that code i would greatly appreciate it. I may be able to use it or modify it to fit my needs, thank you for responding.

I hope it helps. I have attached a workbook where the codes are working. I thought if you saw what it does it might help you see how you can adapt it. Good Luck
Remember to put your email address in the worksheet column 'J' so it can send you the message. It auto sends when the book is first opened so after putting in your email address close the book and then re-open it

I have uploaded your workbook with the code I use in it, if you put your email address in column AP it will send you the message from AQ. AR.
I wish I could help you a bit more but I'm just fumbling my way around the coding although with the help of those on this forum I am improving.
I have put a macro button on your sheet for testing purposes so you don't have to keep closing and opening the book to see if it works - Good Luck

Book2.xlsx

Ok I'm thinking this might be easier. I want to have a code that I can put in multiple worksheets throughout the workbook that will send an email when the date in column AE is reached. I hopefully want to see if it can only send one email per day no matter how many dates are reached or how many times the workbook is opened. Also is it possible to have something like this run automatically without opening the workbook?