Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2016
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to automate Excel to Outlook task update with VBA

    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.
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    Seawell,

    If you upload a non VBA (.xlsx) version of your workbook with no code and I will be happy to show you the code you need to complete your project.

    Maud

  3. #3
    New Lounger
    Join Date
    Feb 2016
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you so much for taking the time to read my request. I appreciate your offer to help. See attached for the requested file format.
    Attached Files Attached Files

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    Thank you for the macro free workbook. I will be examining it this weekend.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •