+ Reply to Thread
Results 1 to 2 of 2

VBA to sync Excel To-Do sheet with Outlook Tasks (2010)?

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    13

    VBA to sync Excel To-Do sheet with Outlook Tasks (2010)?

    Greetings!

    I'm an ultra novice when it comes to VBA and have always been able to search for, find, and then make tiny modifications to suit my needs, but this time I need serious help!

    I have a custom client tracking and to-do workbook I've been building. I'm looking for code that will sync the first worksheet in my workbook, which contains my to-do list, with Outlook 2010 Tasks. I need it to be a two-way sync because I often create new tasks on my Android device via Exchange when I'm out of the office and I want those tasks to appear on my Excel to-do list when I open the file.

    My file is attached, but below is a basic map of columns on the worksheet that I want to sync to Outlook tasks:

    Col. A (Client) & Col. B (to-do) = Task Subject (Concatenate, separated by "/" or ":" etc. )
    Col. C = Start Date
    Col. E = Status
    Col. F = Due Date

    Now if I were to create a task remotely on my Android device and it syncs with Outlook, and then in turn syncs to the Excel worksheet, that task will not have a designation for Column A, so that can be blank or just a placeholder like, "Select Client".

    I found this code somewhere, which was written to accomplish something similar to what I'm looking for, but I'm not savvy enough to take the code I need and modify it to suit:
    Please Login or Register  to view this content.

    Please let me know if I need to elaborate!
    Thank you so much!
    Attached Files Attached Files
    Last edited by JBeaucaire; 05-06-2013 at 07:56 PM.

  2. #2
    Registered User
    Join Date
    04-11-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: VBA to sync Excel To-Do sheet with Outlook Tasks (2010)?

    Anyone out there have any ideas?
    So very much obliged!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1