e-mail warning from Excel

[americanpie3]

Hello,

I have a plan to create an excel sheet DB of softwares I sold to clients. Each license lasts 1 year. Here's an example of my sheet:

Book1
	A	B	C	D	E	F
1	SoftwareDB
2
3	Companyname	Softwaresold	Datesold	Effectivelicensedate	Enddate	Price
4
5	A1	SymantecAV	29/01/2007	31/01/2007	30/01/2008	Toomuch
Sheet1

Of course there will be many more companies and softwares sold.

What I would like is to create a macro that will scan my sheet of my End Date and e-mail me and my boss when the End Date is one month from the license to expire.

Thank you

 

[americanpie3]

Yep here's the result:

SoftwareDB.xls
	A	B	C	D	E	F
1	SoftwareDB
2
3	Company	SoftwareSold	Datesold	Effectivelicensedate	Enddate	Price
4
5	Column1	Column2	Column3	Column4	Column5
6	TrafficTech	BackupExec11D	22/02/2007	22/02/2007	22/02/2008
7	TrafficTech	BackupExec11D	22/02/2007	22/02/2007	22/09/2007
Sheet1

Now what you don't see is that the row of column 1 2 3 4 and 5 are in dark blue and the following lines are also in blue but in a lighter shade as the rows go down.

 

[americanpie3]

Is there a code that will exist to verify the dates and then warn me by e-mail the results?

Thanx