VBA for Email Reminders (Outlook)

Hello, I'm looking to use VBA to send emails, using Outlook, based upon specific dates. Below is an explanation of columns:

A: License Name
B: License Purchase Date
C: License Expiration Date
E: 3 Months Prior to Expiration Date
F: 1 Week Prior to Expiration Date

What I'm looking to do is have Excel send me an email 3 months before the license expires (including the license name from column a and the expiration date from column C), as well as another reminder 1 week prior to expiration. Any help would be greatly appreciate - thanks!

.
Here are two examples you can review and edit to your needs :

30 days out :

Please Login or Register  to view this content.

X Days Ahead :

Please Login or Register  to view this content.

I copy and pasted your code into my VBA. I changed the reference from A1 to B2 for n as B2 is the first cell in which the expiration dates can be found. I'm looking for something to automatically run the macro for me without me having to open the workbook everyday and click on the macro in order for it to run.

.
You will need to open the workbook in order for it to function as desired.

In the VBE, in the ThisWorkbook module, you can select the Workbook_Open and place a call to the email macro there.

Example :

Please Login or Register  to view this content.

Anytime you open the workbook, the macro will auto run.