Ignorant noob presumes to ask a Question:

[riprap]

Hello, All
[Access 2002, Outlook 2002, WinXP Pro]
I've been trying for what feels like hours to create a LINK from one
of my Outlook email folders to an Access database table. No luck so
far. Can someone enlighten me on this process?
Example/Situation: I've got an email folder called NoobMail1. I
create an Access db called AllNoobMail. I go into Outlook and
'manually' export the NoobMail1 folder to a table in the .mdb.
No problems so far.
Now I'd like to create a live link between that email folder and its
mdb counterpart. From within Access I click on File > Get External Data

Link Tables. It brings up a window titled 'Link'. I go down to the text box at the bottom of that Link window, to where it says "Files of Type", and choose "Outlook()". This brings up the Link Exchange/Outlook Wizard window. Here's where the problem hits. The window offers a choice of items to link to, such as Address Books, Personal Folders, & Archive Folders. I've tried & tried but cannot navigate to the email folder for NoobMail1. (I don't even know where the individual email folders are located on the drive; maybe if I knew that I'd get somewhere?)

I'm sure there's a laughably-simple explanation for the steps
necessary for linking that .mdb file to its corresponding email
folder--but I'll be derned if I can figure it out. Do I need to have a
M$oft Exchange account or what?
TIA for any valid suggestions you could send my way!

 

[Arvin Meyer [MVP]]

You've got it so far, click on the small plus sign (+) next to the Inbox and
expand the Inbox folders, you should see NoobMail1. Select it, and you're
done.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hello, All
[Access 2002, Outlook 2002, WinXP Pro]
I've been trying for what feels like hours to create a LINK from one
of my Outlook email folders to an Access database table. No luck so
far. Can someone enlighten me on this process?
Example/Situation: I've got an email folder called NoobMail1. I
create an Access db called AllNoobMail. I go into Outlook and
'manually' export the NoobMail1 folder to a table in the .mdb.
No problems so far.
Now I'd like to create a live link between that email folder and its
mdb counterpart. From within Access I click on File > Get External Data

Link Tables. It brings up a window titled 'Link'. I go down to the text
box at the bottom of that Link window, to where it says "Files of Type",
and choose "Outlook()". This brings up the Link Exchange/Outlook Wizard
window. Here's where the problem hits. The window offers a choice of
items to link to, such as Address Books, Personal Folders, & Archive
Folders. I've tried & tried but cannot navigate to the email folder for
NoobMail1. (I don't even know where the individual email folders are
located on the drive; maybe if I knew that I'd get somewhere?)

I'm sure there's a laughably-simple explanation for the steps
necessary for linking that .mdb file to its corresponding email
folder--but I'll be derned if I can figure it out. Do I need to have a
M$oft Exchange account or what?
TIA for any valid suggestions you could send my way!

 

[riprap]

Hello, Arvin
Thanks much for the reply.
I've already tried that, i.e. clicking "on the small plus sign". All
that is revealed is the Deleted Items folder, and one other (I'm not on
the box in question right now), I think it's the Contacts folder. On
the Outlook installation that's being referred to, I've got probably
7-8 different 'personal' email folders, and NONE of them show up when I
expand that plus sign.
One question for you: Could my problem basically be that I don't have
the correct/necessary ODBC drivers installed which would allow Outlook
to fully-link to Access?
Like I sd, Thanks for taking the time to reply [:-D
If you have any thoughts on the ODBC driver question or another
possibility, please respond.

riprap
**********

You've got it so far, click on the small plus sign (+) next to the Inbox and
expand the Inbox folders, you should see NoobMail1. Select it, and you're
done.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

<snip!>

 

[Guest]

Do you possibly have other Outlook profiles on the PC in question? Try
right-clicking the Outlook shortcut on your desktop. Select Properties with a
left-click. Then click on the Show Profiles... button. My guess is that you
have more than one profile, and the one that you want to link to is not your
default profile.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

Hello, Arvin
Thanks much for the reply.
I've already tried that, i.e. clicking "on the small plus sign". All
that is revealed is the Deleted Items folder, and one other (I'm not on
the box in question right now), I think it's the Contacts folder. On
the Outlook installation that's being referred to, I've got probably
7-8 different 'personal' email folders, and NONE of them show up when I
expand that plus sign.
One question for you: Could my problem basically be that I don't have
the correct/necessary ODBC drivers installed which would allow Outlook
to fully-link to Access?
Like I sd, Thanks for taking the time to reply [:-D
If you have any thoughts on the ODBC driver question or another
possibility, please respond.

riprap
**********

You've got it so far, click on the small plus sign (+) next to the Inbox and
expand the Inbox folders, you should see NoobMail1. Select it, and you're
done.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

<snip!>

 

[riprap]

Hello, Tom
Your suggestion was spot on--I went into the Outlook profiles
properties, and found a 'spare' profile on a network drive. After
making sure that the profile was obsolete, I removed it from the
Properties window (and deleted it from the drive), went back to the
..mdb and performed exactly the same table-linking steps, and voila!
there were all the personal email folders in question! Now to get to
work hunting down some code to link the email Date Received field to
that db....
Thanks very much for your input, Tom [:-D

riprap

Do you possibly have other Outlook profiles on the PC in question? Try
right-clicking the Outlook shortcut on your desktop. Select Properties with a
left-click. Then click on the Show Profiles... button. My guess is that you
have more than one profile, and the one that you want to link to is not your
default profile.

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/e...http://www.access.qbuilt.com/html/search.html
__________________________________________

Hello, Arvin
Thanks much for the reply.
I've already tried that, i.e. clicking "on the small plus sign". All
that is revealed is the Deleted Items folder, and one other (I'm not on
the box in question right now), I think it's the Contacts folder. On
the Outlook installation that's being referred to, I've got probably
7-8 different 'personal' email folders, and NONE of them show up when I
expand that plus sign.
One question for you: Could my problem basically be that I don't have
the correct/necessary ODBC drivers installed which would allow Outlook
to fully-link to Access?
Like I sd, Thanks for taking the time to reply [:-D
If you have any thoughts on the ODBC driver question or another
possibility, please respond.

riprap
**********

<snip!>

 

[Arvin Meyer [MVP]]

Link the entire table and use a query to get the Date Received field's data.
Works directly from the interface, no code needed unless you are going to
use the data as part of another routine.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hello, Tom
Your suggestion was spot on--I went into the Outlook profiles
properties, and found a 'spare' profile on a network drive. After
making sure that the profile was obsolete, I removed it from the
Properties window (and deleted it from the drive), went back to the
.mdb and performed exactly the same table-linking steps, and voila!
there were all the personal email folders in question! Now to get to
work hunting down some code to link the email Date Received field to
that db....
Thanks very much for your input, Tom [:-D

riprap

Do you possibly have other Outlook profiles on the PC in question? Try
right-clicking the Outlook shortcut on your desktop. Select Properties
with a
left-click. Then click on the Show Profiles... button. My guess is that
you
have more than one profile, and the one that you want to link to is not
your
default profile.

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/e...http://www.access.qbuilt.com/html/search.html
__________________________________________

Hello, Arvin
Thanks much for the reply.
I've already tried that, i.e. clicking "on the small plus sign". All
that is revealed is the Deleted Items folder, and one other (I'm not on
the box in question right now), I think it's the Contacts folder. On
the Outlook installation that's being referred to, I've got probably
7-8 different 'personal' email folders, and NONE of them show up when I
expand that plus sign.
One question for you: Could my problem basically be that I don't have
the correct/necessary ODBC drivers installed which would allow Outlook
to fully-link to Access?
Like I sd, Thanks for taking the time to reply [:-D
If you have any thoughts on the ODBC driver question or another
possibility, please respond.

riprap
**********
Arvin Meyer [MVP] wrote:
You've got it so far, click on the small plus sign (+) next to the
Inbox and
expand the Inbox folders, you should see NoobMail1. Select it, and
you're
done.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

<snip!>