Automatically send an email based on the value of a cell and/or trigger date
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!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1