Hi Guys,
We create basic spreadsheets to keep track of tasks and reviews. Often spreadsheets have different formats with one thing in common. Each will have a due date.
I would like be able to create Macro / VBA to send email and/or task for due dates in multiple excel sheets.
Some of the above might be wish list and can be omitted but the essence is upcoming and overdue items to be sent to email / reminders to Outlook.
Any help would be appreciated.
We create basic spreadsheets to keep track of tasks and reviews. Often spreadsheets have different formats with one thing in common. Each will have a due date.
I would like be able to create Macro / VBA to send email and/or task for due dates in multiple excel sheets.
- Using MS EXCEL2007 and OUTLOOK 2007
- Reminder to be sent at trigger event dates 14 days,7 days, 2 days before due and every day overdue
- Due dates could get color coded as they approached deadline. For e.g Over 14 days (nil), 14 days (green), 7 Days (orange), 2 days/ overdue (Red).
- Due dates could be always put in column A for example for simplicity and consistency if necessary or perhaps it could work of Column heading (DATE DUE).
- Also for simplicity emails would only need to go to 2 people. From there we can forward to relevant people after being aware of task ourselves.
- When multiple trigger events occur within same Spreadsheet, Have the one email rather than 20 if twenty occur on same day. Different spreadsheets emails are fine.
- A check that if email has been sent it will not send another email till next date trigger event.
- A 'Send Email' button for all trigger events and another Send selected email' button for one or more selected rows only.
- Text in subject line email could be Excel file name
- Text in body of email would include Excel file name and Title row and trigger event row.
Some of the above might be wish list and can be omitted but the essence is upcoming and overdue items to be sent to email / reminders to Outlook.
Any help would be appreciated.