Check date, auto email

Hiya,

So every 30 days we have to complete a set of tasks. People are checking the spreadsheet each day for each task to see if the 30 days has come yet (there are maybe 500 rows of data). This makes no sense. It's time consuming, but with the way the tasks are scheduled and set up, we can't use a calendar etc. (too much to get into).

So I'm looking to:

1. Have a macro scroll through a list of dates in column H
2. Once it has determined one (or any) of the dates has hit the 29 day mark, send an email
3. Have information from column A and B in the body of the email (they'll need to know the details of the task)

Is this too much to expect from a macro? Would I need to run the macro myself, or could I have it auto run each morning (I'd prefer the auto run, so it'll do it on the weekend when I'm not around too).

I appreciate any and all help!

J

Excellent question. Sorry I forgot to mention that. No, since the user will need to go in and perform the task, the date doesn't need to be updated in Column H (I'd prefer it wasn't until someone performs an action). Thanks!

I'd like to say no, since I think enough people would be copied on the first one, but I think it'll be harder to keep it from doing that since the macro would be scrolling through the dates each and every day (and picking up on the same ones over and over again).

Sorry (again), yes it will be from (and to) outlook email addresses.

The email addresses aren't located anywhere in the spreadsheet, but they'll always be the same. There will probably be five people on the distro (To) list. I can add the addresses into the macro in the appropriate section etc.

Thanks, I'll give this a try and report back. I appreciate all your help.

Question: I (or someone else) can open the spreadsheet to kick off the macro, but is there a way to have it run without opening it or is this the only way? It's still helpful either way, I'm just curious. Thanks again.