Is there a way to do a search in Access, and search in Outlook?

[anoble1]

Hi,

I work in IT. I have people calling all during the day. I was wanting to make a tool where I could do a search on Network ID or Logon ID, and have it search outlook and pull all the users info. Has anyone done that? Is it possible in Access?

thanks,

[NeoPa]

Access supports both searching and filtering. Personally, I find the latter far more useful generally.

Example Filtering on a Form gives help on setting up some filtering. I think designing a database to support you in your work is a great idea :-)

[anoble1]

Maybe there is a way in MS Access to Link a table to MS Outlook that way it always is up to date, if I am not able to use a function?

[NeoPa]

I'm not sure about that. If I were looking into that I'd be thinking of LDAP (Lightweight Directory Access Protocol). I know I've used it before when dealing with the Active Directory, and it was designed originally for mail systems I believe.

Otherwise, one approach might be to use Application Automation to grab the data you need from outlook and load it into a table.

I suggest that this thread is too broad of scope to be covered here well. Are you searching or finding out how to interact with Outlook. We'll do what we can to help with either situation, but they shouldn't be bundled together in a single thread. I'll leave that thought with you.