Generate email from worksheet based on multiple cell values

Hi. I have a worksheet measuring staff attendance on various courses. Using date-today, a 'days lapsed' value is calculated in column D. If the value of the cell in column D exceeds 365 days, an email is generated to that member of staff using the following code in a module;

Please Login or Register  to view this content.

This works fine on a single column, but if I wanted to add another set of columns e.g. if I had columns F, I and J set to measure different lapses e.g.100, 200 or 300 days respectively, could I incorporate this code into the same module? I have tried using a new module for each column, but come up with

Ambiguous name detected; Testfile

warnings. Any info gratefully received,
Mattbro

Hi

You could just rename your other macros to Testfile2, Testfile and Testfile4, then each would run independently.