I'm working with a spreadsheet that has a collumn for trigger dates in contracts and I need to create a macro that will automatically email certain individuals to alert them of these triggers. A couple of things though...

I need the email to extract the contract name in the corresponding row so that when there is a trigger date, the individual will be told to look at the corresponding contract. So, if the trigger date is today, I will need the email to extract the value of the field that the corresponding contract name is located in.

I also need to make sure that only one email is sent... In other words, the macro has to account for the fact that an email has already been sent for a certain trigger...

Thank you very much for any assistance you can provide! I am very new to VBA and Macros, so please assumed that I know nothing about this process!