Full Outlook imported to Access

[jon.ingram]

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 I can not get the full email address w/domain name to import
into my table. Is there a way to achieve this?

 

[Tom Wickerath]

Hi Jon,

Yes, there is a way to do this. I have a sample available, but it is not
currently posted for download. If you send me a private e-mail, I will send
you a zipped copy of my sample database. My e-mail address is available at
the bottom of the contributor's page indicated below. Please do not post your
e-mail address (or mine) to a newsgroup reply.

Note: It's not a good idea to include a valid e-mail address in any
newsgroup posting. Doing so will only attract the unwanted attention of
spammers. I removed your full address from this reply.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________