Greetings all,
I am attempting to code a macro that sits on a worksheet of email addresses.
The list of email addresses also has columns stating whether a person is available or not. It also has a column with an assigned task.
What I would like the macro to do is read a 2nd excel file which has a list of job tasks on it. If a job task from this 2nd file matches the a task assigned to the email address, it will send an email to that person, advising them of the task.
Any help with this will be greatly appreciated.
I am attempting to code a macro that sits on a worksheet of email addresses.
The list of email addresses also has columns stating whether a person is available or not. It also has a column with an assigned task.
What I would like the macro to do is read a 2nd excel file which has a list of job tasks on it. If a job task from this 2nd file matches the a task assigned to the email address, it will send an email to that person, advising them of the task.
Any help with this will be greatly appreciated.
