Auto send emails base on cell being within 30 or 90 days excel.

[hooper12345]

Hello,
I have an excel workbook that I am willing to privately share as well as the code i'm hung up on. Basically I would like it to scan the dates in column c and if it is within 30 or 90 days of Today then it will auto send an email to the email address in column b. I have been getting stuck on the formula to recognize the 30 and 90 days.

As always, help is greatly appreciated.

 

[MisterProzilla]

I'm not sure how you would do the date calculations within vba - there will be a way, I just haven't done it before. But that also leaves you with the issue that once it's sent, you need to mark it as having been sent - I'm assuming you don't want to repeatedly send emails.

Personally, I would add a 'status' column, and two 'sent' columns, one each for the 30- and 90-day emails. The status column would flag up which one of the emails is due, then you'd have either a VBA button or an Autpen macro that goes through each row, looks for an email ready status, composes and sends, then marks the appropriate 'sent' column on that row.

Does that sound like the kind of thing you're after? If so, I'll work through the formula and code for you

 

[Peter_SSs]

I have an excel workbook that I am willing to privately share ...

That is not permitted - refer to #4 of the Forum Rules

 

[hooper12345]

Says "Members should not use the Private Message system to request specific assistance", which I didn't. Thanks.

 

[Peter_SSs]

Says "Members should not use the Private Message system to request specific assistance", which I didn't. Thanks.

It also says "Do not invite another member to take the question off the forum. ... This applies equally to members asking or answering questions." You have invited all/any member to receive your data, and therefore effectively your question, privately. That is, off-forum.

We are a public forum and all correspondence and data should be as public as possible. I also refer you to the 3 notes at the top of the Rules.