Hi Guys,
I have a spreadheet with a list of actions on it each with a spcific deadline, and each with a specifc owner. What i am trying to do is to create some VBA code which will automatically look up the due date of the action and if it is upcoming (say within 15 days of the date) then an email is generated to the individual (who's email address will be held on the same row of data).
Is this possible ,if not would it be possible to have all emails sent to my email address.
so for example i have in cell A1 the current date
row I has the name of the report which i want to put in the subject section of the email.
row p has the content that i want to include in the email
row c has the email address of the person responsible for the action.
can anyone help?
Thanks in advance
Bookmarks