Linking Outlook Tasks to Access does not pull any significant fields?

Hello - I linked Tasks from Outlook 2010 into Access 2010, and was floored to see how few fields were exposed.

Is there a way to at least get the Subject and Categories?

Thanks
mlagrangeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm pretty sure that's by design, and there's not much you can do about it in terms of a straight link.

You can automate Outlook and get a lot more information about the Task:

Function TestOL()
    '/ must have reference to Outlook, useful for intellisense during development
    '/ should change to Late Binding if you're deploying to others
    Dim olk As New Outlook.Application
    Dim olns As Outlook.NameSpace
    Dim tsk_fld As Outlook.MAPIFolder
    Dim tsk_itm As Outlook.TaskItem
    Dim olk_itms As Outlook.Items
    '/ open the outlook connection
    Set olns = olk.GetNamespace("MAPI")
    '/ get the Tasks folder
    Set tsk_fld = olns.GetDefaultFolder(olFolderTasks)
    '/ Get the Items in the Tasks Folder
    Set olk_itms = tsk_fld.Items
    '/ loop through the tasks
    For Each tsk_itm In tsk_fld.Items
        With tsk_itm
            '/ only get those that are not complete
            If Not tsk_itm.Complete Then
                MsgBox .Subject & " - " & .ActualWork & " - " & .Categories
            End If
        End With
    Next
    '/ cleanup
    Set olk_itms = Nothing
    Set tsk_fld = Nothing
    Set olns = Nothing
End Function

Open in new window


You could then write that to a table, if needed, and do what you want with that table.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlagrangeAuthor Commented:
Works like a charm! Thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.