Simple Excel expiry dates to email notifier

HI there,
First time user of Experts Exchange.

I am looking for the simplist way to take my expiry dates for certifictaions, ie. forklift license, fall protection certifrications, first aid certifications, and get an email sent to me before these dates expire.
pic-of-expiry-dates.PNG
I am ok with excel, but VBA, (Please be gentle on me) I have no clue. Is there a way to do this Inside of Outlook itself, or do we have to do this in excel and run VB to email.?

Thanks so much.
chris pikeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kgerbChief EngineerCommented:
Hello Chris,
Take a look at the attached workbook.  You'll need to have outlook running in the background.  Click the button and see what happens.  This should provide a good starting point.

Also, notice I normalized the data.  This makes is much easier to loop through and pick out the dates which are about to expire.  Please consider re-configuring your data to look like this.

Thanks,
Kyle
Q_28733860-RevA.xlsm
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chris pikeAuthor Commented:
Unbelievable
You are going to get me huge Brownie Points.

Thank you so much.
This is awesome.

Works perfectly.
0
kgerbChief EngineerCommented:
You're welcome.  Glad to help :)

Kyle
1
chris pikeAuthor Commented:
Hi Kyle,
I noticed that i can not add any more lines.
Do I need to change the rng value?

And this runs on the whole workbook, if I wanted to run one report for each sheet would it be hard to do that?>?
Then I could seperate out the categories so I  Could send seperate email to each department leader.

Does that make sense?
Thanks so much.
Chris
0
kgerbChief EngineerCommented:
Hello Chris,
Since this question has been closed, can you please open a new question with your additional requirements.  I will be looking for it and will be more than happy to help you out.  

Thanks for your understanding,
Kyle
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.