I have a worksheet that opens daily. 3 columns have dates in them. I already have a code that sends an email out automatically when the current date is reached in any of three columns. What I am trying to so is this: when the workbook opens and it finds the current date in a cell ( or cells) from this column, it goes to the cell in column "A" of that row and places the data in it as the subject line, even if there are multiple cells with the current date in them, meaning I may have more than one cell to use as the subject line. I have dates in columns C,D and E. I would like and cell(s) with the current date to go to Column A of that row and place that data as the subject line.