i required automail vba code. so, if at certain point it auto generate the mail, Example as below

cc: etc...
sub: abc

matter : asdfdbc.....

but if the given cell is below certain value ( less than 2 day to three days ). then it should be autogenerated.

Thanks in advance

Shaison George