Cant put correct cell as subject line in email

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.

Could you could post either an example workbook or the code that you are using?

Please Login or Register  to view this content.

Try adding a portion that moves the dates and then add that value to EmailSubject line ie

Please Login or Register  to view this content.

Your code needs to go inside of the For Each loop though except for all of the dim statements

The dates are produced froma formula that gets data from the date in a different column. Not sure what you mean by moves the dates but I need the spreadsheet to stay as is...just thot there may be a code snippet to help with the subject line.

So column A already has the date in it and you want to add that date to the subject line. try adding

Please Login or Register  to view this content.

Column A has names. Column B has hire dates. Each column after that ( C,D, and E)'s dates are derived from the date in column B. Each has an amount days added to them to trigger reminders. So when any of them ( except column B) equals the current date, I have the email sent out. I would like the subject to be the name (in column A) that corresponds to the row where the date is matched with the current date . In theory, this may be more than one name matches the criteria.

Ok so the code I put in the last one will loop through and create an email for every name in column a and that is not what you want. The only solution I can think of would be to add loop through column a then use if statements to trigger the creation of the email.

I already have the whole thing working good. Everyday, the computer opens this workbook automatically. When it opens, it runs the code automatically. If any of the dates in columns C,D, or E equals the current date when the workbook is opened, it triggers an email to be sent along with a pdf of the worksheet. The receiver of the email can look through the pdf image and see who needs the attention. But if this list gets long, and it may, it would be nice to have the names of the persons put in the subject (or even body) of the email to help identify the problem person. I really dont want to change the trigger for the email. I just thought there might be a code that finds the current date...goes to the name in that row (column A), and adds it as a subject...continues adding names if necessary.

If your sending a pdf of the worksheet then why not highlight the problem person with a workbook change event that highlights fills the cell with a color

Please Login or Register  to view this content.

I already have that happening in conditional formatting. Like I mentioned, the person receiving the email can always scan down through the pdf and manually find the problem person. But if this list has 250 people on it, and only three are problem people, then it would be a lot easier to have their names as subjects, saving alot of time.

Well I am all out of ideas on that front then. Sorry I was not able to be more helpful

That's completely ok. I appreciate your time and effort.