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 let me know if I need to elaborate!
Thank you so much!
Bookmarks