Generate E-mail from within Excel based on conditional format outcome. 2

[wbow]

Hi,
I have a created a spreadsheet [Excel 2003]for a non-technical user which lists engineers, who they report to and a listing of their qualification along with the qualification expiry dates.

I have used conditional formatting to change the colours of the dates when they are 6 months from exipry [amber] and expired [red].

I have been asked if it is possible to e-mail each record where either of the two conditions above are met, to whom they report to from within Excel.

Can anyone suggest a method [VBA maybe?] to achieve this?
Many thanks.

 

[SkipVought]

Hi,

Definitely VBA. Forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SPV]

Or, within Excel itself, why don't you move the formatting condition to an extra column (one column per condition - hide the columns if you want to). Then both your conditional formatting and your email routine could check the true/false in the cell.