Importing Outlook Inbox to access (email address)

[jon.ingram]

I have successfully imported my outlook inbox to accesss unfortunately
the email field only shows the name of the individual that emailed and
not their full address, for example Joe Smith says "Smith, J" rather
than (e-mail address removed). Is there a way to import the full email
address?

Thanks,

JI

 

[DL]

Why did you import and not open the data file?
Are your addresses (Contacts) not contained in your origonal data file?
and if they were, they would be accessible if you opened the old data file.

 

[jon.ingram]

Why did you import and not open the data file?
Are your addresses (Contacts) not contained in your origonal data file?
and if they were, they would be accessible if you opened the old data file.






- Show quoted text -

Let me try to explain differently. I have an outlook inbox that I
need to run reports off of, (ie how many distinct people emailed us
this month?, What domain were they from?, etc.) I am able to take the
outlook inbox and import to access for reporting/querying purposes
which its great b/c it makes the process fairly automated. The only
problem, as stated above is, I can not get the full email address w/
domain name to import into my table. Is there a way to achieve this?

Thanks

 

[Gordon]

Let me try to explain differently. I have an outlook inbox that I
need to run reports off of, (ie how many distinct people emailed us
this month?, What domain were they from?, etc.) I am able to take the
outlook inbox and import to access for reporting/querying purposes
which its great b/c it makes the process fairly automated. The only
problem, as stated above is, I can not get the full email address w/
domain name to import into my table. Is there a way to achieve this?

Do you actually have to do an import? Does Access allow you to use a pst
file as a direct Data Source?

 

[Sue Mosher [MVP-Outlook]]

Gordon, Access does indeed allow you to use Outlook folders directly, but
it's not a very useful technique, because it lacks the ability to show even
all the reasonably important fields. While articles have been written on how
to expand on this method's obvious features, I've never been able to
duplicate the results. See http://www.outlookcode.com/article.aspx?ID=25 .

Jon, that page will also give you other ideas on how to work with databases
and Outlook together. In general, you'll need to write code or use a
third-party tool that does the heavy lifting. Importing and linking just
aren't good enough.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[Gordon]

Gordon, Access does indeed allow you to use Outlook folders directly, but
it's not a very useful technique, because it lacks the ability to show
even
all the reasonably important fields. While articles have been written on
how
to expand on this method's obvious features, I've never been able to
duplicate the results. See http://www.outlookcode.com/article.aspx?ID=25 .

Thanks for the info!