Automatic email reminders based on different deadlines on Excel

there are plenty of previous examples of this on this forum of which you can draw from

here's one i did some time ago which is very similar to your issue
http://www.excelforum.com/excel-prog...xcel-file.html

do your 3 types of email overlap? if not there you dont need to seperate the macro into 3 chucks like you have

ie would you send 1st 2nd and 3rd type of email all at the same time?
the way you describing it doesnt sound like it
as D is start date
G is 4 weeks in
I is 10 weeks in
so they sound be mutually exclusive

im also assuming your columns E,J and H are checks
ie...if you have sent an email you wont continuously email every time you open the workbook is that correct?
or if you haven't opened file in few days it counts back as well?

see attached
i made it .display instead of .send
you really shouldn't do .send unless its final

re: attachment
left blank space with comment in there for you
read this site for how to do it
http://www.rondebruin.nl/win/s1/outlook/amail1.htm

ive restructured your loop so it checks every row just once

firstly for completed...if its completed goto next row
then it checks the date so see where it should slot in then on the cell next to date to see if that cell is empty
if it is empty then send email otherwise it assumes email has been already sent previously

Can the email be sent regardless I open the workbook or not?

no, this is not possible
you are required to open the workbook to trigger the effect

Does the email send at random times on the particular date it's supposed to send?

no it tries to send when you open the workbook
so if you open workbook...send email and dont save...it will try email same email again
so remember to save on exit

it uses the "default" outlook account on the computer than runs the code
so if outlook is not installed on that computer it will not work
if you are going to use this on other computers/setups i would suggest testing the water first with macro that is manually run instead of automatically just in csae

if you have more than one and you want to check or change account
http://www.rondebruin.nl/win/s1/outlook/account.htm

if you havent noticed already i refer to Ron's website a lot when dealing with VBA email (also great for other code but especially for Email)

not a problem

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Hey mate, my apologies, just one last question:

I tried the macros and it works brilliantly. Except when the email is sent, apart from the generating out the reminder detail in Column E, it also automatically changes column F to "Completed", which should not be the case.

The "Completed" should be selected by the user manually and by doing so, will prevent further email sent.

EDIT:
Alright, I found out why! I just removed this line

End with

Cells (i,6) = "Completed"

Thanks!