Alert prompt if date and time is reached

So in a sheet called Sims, I want to be prompted automatically if the date in cell D2 and the time in E2 have both passed. If they have passed I ideally would like an email to be automatically sent to an address saying this. My outlook will always be open for this. Ideally the subject would be whatever is contained in cell A2 and 'needs looking at'. So if cell A2 said Tigers, and the date and time were both in the past then an email would be sent with the subject 'Tigers needs looking at'.

There will also be dates and times all the way down to row 20 and the same will need to happen for those. So the macro would check which rows meet the criteria and then send an email each time the criteria are met.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I think the code opens up a new instance of outlook anyway. It shouldn't matter if outlook is open or not.

add

Please Login or Register  to view this content.

and put an if statement along the lines of:

Please Login or Register  to view this content.

since it's two different macros though, won't I need something like Sub emailHim(ByVal x as Integer) so the macro that actually sends the email knows which cell to use when populating the subject line?

Sorry I missed it was two separate macros. Probably need this:

Please Login or Register  to view this content.

Thanks for that. Works how I want now. I just tried running the macro with outlook closed though and it ran without error but did not send the email as outlook was closed and it didn't open outlook for me. Ideally I want it to Open outlook if it isn't already and then send it.

How would I finally alter the code so that if I have another sheet within the workbook open, it knows to look at the sheet with the correct data on and run it based on that. The sheet with the correct data is called Data1. When I added the above to the workbook I need it on, it doesn't run when I have other sheets open. However, if I have the sheet open and run it, it obviously runs fine.

One way:

Please Login or Register  to view this content.