Mine Outlook

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

So, I'm about to add a couple fields to a user table in my Access 2007 db
when it dawns on me...I use Windows authentication already to identify my
user. Why not just go to Outlook and find the user's pager number and stuff?
It's already there, I just don't know how to get to it.

Any ideas? I'm thinkin' real-time instead of storing the data in Access.
What do you guys (you know who you are...Tony...) think? Resources?
 
If Outlook is not open you will have to open it and then close it afterwards.
If Outlook is open you need to use the one that's open and not open another.
Apart from that, its a matter of becoming familiar with the Outlook Object
model.
Unless you can find some canned code, expect to spend days or weeks figuring
it all out.
Your first step is to go to the Object Browser. You'll need to add the
reference for Outlook.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
If Outlook is not open you will have to open it and then close it afterwards.
If Outlook is open you need to use the one that's open and not open another.
Apart from that, its a matter of becoming familiar with the Outlook Object
model.
Unless you can find some canned code, expect to spend days or weeks figuring
it all out.
Your first step is to go to the Object Browser. You'll need to add the
reference for Outlook.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Oh, I've become an expert at MSOffice objects -- Access, Excel, Project! --
to the point where I fool myself into believing I understand them. OK...I'll
tinker.
 
Oh, I've become an expert at MSOffice objects -- Access, Excel, Project! --
to the point where I fool myself into believing I understand them. OK...I'll
tinker.
 
Hi Jim

You can actually link your Outlook contacts as a table in your Access
database.

Start the table linker and select Files of type: Outlook()

You will then see a tree view of all your Outlook folders - browse down it
and select your Contacts folder, then click Next and Finish.

The only problem I can see is that Outlook appears to have no concept of a
primary key that you could use to link the contact record with your database
table (not one exposed in the linked table, anyway). If there is
consistency and uniqueness is, say, the email address then you could use
that.

If you wish to use automation, I can tell you that the object in question is
a ContactItem. Each ContactItem has an EntryID property, which is a unique
string (somewhere in the order of 20 chars).

If you were to store this EntryID string in a unique index field in your
Access table, then you could retrieve the desired ContactItem object quickly
using the GetItemFromID method:

Set objContact = objNameSpace.GetItemFromID( strEntryID )

I hope this is enough to reduce the "days or weeks" to "hours"!
 
Hi Jim

You can actually link your Outlook contacts as a table in your Access
database.

Start the table linker and select Files of type: Outlook()

You will then see a tree view of all your Outlook folders - browse down it
and select your Contacts folder, then click Next and Finish.

The only problem I can see is that Outlook appears to have no concept of a
primary key that you could use to link the contact record with your database
table (not one exposed in the linked table, anyway). If there is
consistency and uniqueness is, say, the email address then you could use
that.

If you wish to use automation, I can tell you that the object in question is
a ContactItem. Each ContactItem has an EntryID property, which is a unique
string (somewhere in the order of 20 chars).

If you were to store this EntryID string in a unique index field in your
Access table, then you could retrieve the desired ContactItem object quickly
using the GetItemFromID method:

Set objContact = objNameSpace.GetItemFromID( strEntryID )

I hope this is enough to reduce the "days or weeks" to "hours"!
 
Thanx Graham...I really appreciate it. My fear ismy client of course uses
Exchange, so it could be different. We'll see! Thanx again!!
--
Jim


Graham Mandeno said:
Hi Jim

You can actually link your Outlook contacts as a table in your Access
database.

Start the table linker and select Files of type: Outlook()

You will then see a tree view of all your Outlook folders - browse down it
and select your Contacts folder, then click Next and Finish.

The only problem I can see is that Outlook appears to have no concept of a
primary key that you could use to link the contact record with your database
table (not one exposed in the linked table, anyway). If there is
consistency and uniqueness is, say, the email address then you could use
that.

If you wish to use automation, I can tell you that the object in question is
a ContactItem. Each ContactItem has an EntryID property, which is a unique
string (somewhere in the order of 20 chars).

If you were to store this EntryID string in a unique index field in your
Access table, then you could retrieve the desired ContactItem object quickly
using the GetItemFromID method:

Set objContact = objNameSpace.GetItemFromID( strEntryID )

I hope this is enough to reduce the "days or weeks" to "hours"!

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand


JimS said:
So, I'm about to add a couple fields to a user table in my Access 2007 db
when it dawns on me...I use Windows authentication already to identify my
user. Why not just go to Outlook and find the user's pager number and
stuff?
It's already there, I just don't know how to get to it.

Any ideas? I'm thinkin' real-time instead of storing the data in Access.
What do you guys (you know who you are...Tony...) think? Resources?
Click to expand...
Click to expand...
 
Thanx Graham...I really appreciate it. My fear ismy client of course uses
Exchange, so it could be different. We'll see! Thanx again!!
--
Jim


Graham Mandeno said:
Hi Jim

You can actually link your Outlook contacts as a table in your Access
database.

Start the table linker and select Files of type: Outlook()

You will then see a tree view of all your Outlook folders - browse down it
and select your Contacts folder, then click Next and Finish.

The only problem I can see is that Outlook appears to have no concept of a
primary key that you could use to link the contact record with your database
table (not one exposed in the linked table, anyway). If there is
consistency and uniqueness is, say, the email address then you could use
that.

If you wish to use automation, I can tell you that the object in question is
a ContactItem. Each ContactItem has an EntryID property, which is a unique
string (somewhere in the order of 20 chars).

If you were to store this EntryID string in a unique index field in your
Access table, then you could retrieve the desired ContactItem object quickly
using the GetItemFromID method:

Set objContact = objNameSpace.GetItemFromID( strEntryID )

I hope this is enough to reduce the "days or weeks" to "hours"!

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand


JimS said:
So, I'm about to add a couple fields to a user table in my Access 2007 db
when it dawns on me...I use Windows authentication already to identify my
user. Why not just go to Outlook and find the user's pager number and
stuff?
It's already there, I just don't know how to get to it.

Any ideas? I'm thinkin' real-time instead of storing the data in Access.
What do you guys (you know who you are...Tony...) think? Resources?
Click to expand...
Click to expand...
 
You can link Exchange folders also... or automate them via Outlook.

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

JimS said:
Thanx Graham...I really appreciate it. My fear ismy client of course uses
Exchange, so it could be different. We'll see! Thanx again!!
--
Jim


Graham Mandeno said:
Hi Jim

You can actually link your Outlook contacts as a table in your Access
database.

Start the table linker and select Files of type: Outlook()

You will then see a tree view of all your Outlook folders - browse down
it
and select your Contacts folder, then click Next and Finish.

The only problem I can see is that Outlook appears to have no concept of
a
primary key that you could use to link the contact record with your
database
table (not one exposed in the linked table, anyway). If there is
consistency and uniqueness is, say, the email address then you could use
that.

If you wish to use automation, I can tell you that the object in question
is
a ContactItem. Each ContactItem has an EntryID property, which is a
unique
string (somewhere in the order of 20 chars).

If you were to store this EntryID string in a unique index field in your
Access table, then you could retrieve the desired ContactItem object
quickly
using the GetItemFromID method:

Set objContact = objNameSpace.GetItemFromID( strEntryID )

I hope this is enough to reduce the "days or weeks" to "hours"!

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand


JimS said:
So, I'm about to add a couple fields to a user table in my Access 2007
db
when it dawns on me...I use Windows authentication already to identify
my
user. Why not just go to Outlook and find the user's pager number and
stuff?
It's already there, I just don't know how to get to it.

Any ideas? I'm thinkin' real-time instead of storing the data in
Access.
What do you guys (you know who you are...Tony...) think? Resources?
Click to expand...
Click to expand...
Click to expand...
 
You can link Exchange folders also... or automate them via Outlook.

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

JimS said:
Thanx Graham...I really appreciate it. My fear ismy client of course uses
Exchange, so it could be different. We'll see! Thanx again!!
--
Jim


Graham Mandeno said:
Hi Jim

You can actually link your Outlook contacts as a table in your Access
database.

Start the table linker and select Files of type: Outlook()

You will then see a tree view of all your Outlook folders - browse down
it
and select your Contacts folder, then click Next and Finish.

The only problem I can see is that Outlook appears to have no concept of
a
primary key that you could use to link the contact record with your
database
table (not one exposed in the linked table, anyway). If there is
consistency and uniqueness is, say, the email address then you could use
that.

If you wish to use automation, I can tell you that the object in question
is
a ContactItem. Each ContactItem has an EntryID property, which is a
unique
string (somewhere in the order of 20 chars).

If you were to store this EntryID string in a unique index field in your
Access table, then you could retrieve the desired ContactItem object
quickly
using the GetItemFromID method:

Set objContact = objNameSpace.GetItemFromID( strEntryID )

I hope this is enough to reduce the "days or weeks" to "hours"!

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand


JimS said:
So, I'm about to add a couple fields to a user table in my Access 2007
db
when it dawns on me...I use Windows authentication already to identify
my
user. Why not just go to Outlook and find the user's pager number and
stuff?
It's already there, I just don't know how to get to it.

Any ideas? I'm thinkin' real-time instead of storing the data in
Access.
What do you guys (you know who you are...Tony...) think? Resources?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top