Hi All,
I’ve mocked up an excel to-do list to help me with prioritizing work in a more objective way (see attached) – I’ve based it on this. Each task is then linked to where the resources to complete the task are stored. The spreadsheet automatically opens upon computer and excel startup. In the event I can’t come to work anymore anyone would be able to quickly locate the information to complete the tasks.
I’d like to take this to a more automated level and incorporate outlook tasks and reminders. The hitch is that I don’t want to have to maintain both the spreadsheet and the outlook tasks originating from my to-do list in excel.
I’m looking for some direction on how to achieve these requirements:
-
[*]Send outlook task to the current user’s outlook once – no duplicates but if there is a way to update existing if due dates and other timing changed since last import that would be a bonus.
[*]Task body contents to include the information from the row of the task (columns A, D, H, N)
[*]Start Date = column I (Ramp Up – number of days before due date)
[*]Start Date outlook reminder triggered when date met
[*]Due Date = column H
[*]Due Date outlook reminder triggered when date met
[*]Completed Date = column L
[*]Tasks cleared based on completed date
[*]To be run manually
I am aware this is asking for some pretty in depth code but as I said any info to get me started is appreciated.
Thanks.
