Need help with getting excel to automatically send out email....

Hey guys I need some help I have a very basic knowledge of excel but I need some help on how to have excel send out an email to a specific person/company notifying them of either their license or physical expiring soon. I would like to have the email sent out once when there is 30 days before expiration and again if the expiration date has passed. The subject of the email would be "Notice of Expiring Drivers Licenses and/or Physicals". In the body I would like to list all expiring drivers names with their corresponding expiration dates. Or can this only be done 1 driver at a time? Because there might be 5 guys in one company that have expiring dates. I am open to any and all suggestions as to how I can do this. I've attached a very small sample of what I currently use. Please help!!

Exp. Sample.xlsx

What are you using for your email? Outlook?

Yes I'm using outlook

Does this work?

I just noticed a mistake I made. The macro I sent you assumes that the companies (column C) are always grouped together. A simple fix for this is to sort the table by column C before running the macro, or add an automatic filter at the beginning of the macro.