Results 1 to 4 of 4
  1. #1
    dantray02 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    4

    Outlook tasks import

    Hi, I am having trouble viewing the imported tasks from outlook. I have never used access before so the answer is probably quite simple.



    I am using a task template downloaded within access. I have connnected to outlook and have imported data. However, I cannot view these in the list of tasks on the default template I downloaded. Is there a way to connect the two so i can open my outlook tasks in access and update them etc.

    thanks.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    The import wizard will not import and or link every available element within Outlook. I have not used the Wizard a lot but, my experience is that the wizard is selective and does not retrieve all fields/elements.

    I rely on VBA so I can dictate the query.

  3. #3
    dantray02 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    4
    Is there code I can access that will do this? Simply put, i use the standard outlook tasks function, and I would like to use these in access instead and have the two bits of system communicate with each other when i update tasks and close them etc.

    thanks.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    It is not simple and requires some advanced VBA skills as well as a good ability to understand collections and decipher collection properties/methods using help files.

    Here is a link where I start when automating things like Inbox, Contacts, etc.
    http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 07-10-2014, 09:37 AM
  2. Sync outlook tasks
    By slickvick in forum Code Repository
    Replies: 0
    Last Post: 01-20-2013, 09:01 PM
  3. Access and Outlook Tasks HELP!
    By marciehen in forum Access
    Replies: 2
    Last Post: 05-20-2011, 02:41 PM
  4. Outlook tasks export
    By eww in forum Programming
    Replies: 5
    Last Post: 11-12-2010, 03:56 PM
  5. Reading outlook tasks from Access
    By Bill_dom in forum Import/Export Data
    Replies: 0
    Last Post: 08-07-2008, 06:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums