DataBase - Emportingv e-mail into and Access 2003 database

Asked By The Chomp

29-Jan-10 10:59 AM

Good Day.
I am setting up a tracking database and one of the requirements is to import
e-mails into the database.
Does anyone know if this 1) can be done, 2) should be done, or 3) would
there be a better way of doing this

Thanks All.

Chomp

30-Jan-10 05:46 PM

ort

Why do you want/need the e-mails in Access?  Is there something you
cannot do by linking to your Inbox?  Which e-mail client are you
using, Outloook?

29-Jan-10 07:58 PM

Link to Outlook????

I guess I should try to explain what I am trying to do.

I want to track the work that needs to be done by our section on a number of
different projects at the same time. The preferred method of communications
is e-mail. What I wanted to do is link each e-mail to the work that was being
done. This way, all documentation would be available in one tool.
It maybe that I should be using a different tool....


Thanks
Chomp

31-Jan-10 09:46 AM

If you can link to your e-mail's datastore, then you can run a maketable
query the first time you want to append the e-mails to your database.  After
that, you can create a query to do it for you.  Depends on whether Access can
link to the e-mail app's data or not.  What e-mail client are you using?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/201001/1

01-Feb-10 07:28 AM

Thank you.

We are using an exchange server. This being said, I was hoping for something
on the simple side as I am not working with people with a lot of technical
knowledge. As well, I was looking for something that could be maintained if I
was to leave this position.

Thanks Agin

02-Feb-10 01:58 PM

ing
l
if I
ber of
tions
s being
e
=A0After
cess can
ng?

The easy way to do this would be something like this:
1. create a table in Access into which you want to store the e-mails.
-- this could be an issue if you have attachments.  Not entirely sure
how Access07 handles them, but you would have to deal with that part.
2. attach the Outlook folder you have the e-mails in to Access (file/
get external data/switch to Outlook....)
3. use the find unmatched query wizard to get the e-mails from the
Outlook Inbox that are not already in the Access table.
4. turn the query into an append query.

Then it depends on how frequently you want to check the Outlook
account for the e-mail messages.  Danny Lesandrini has code on his
website, Inbox Watcher, that will periodically check the inbox for new
mail, (basically a form with a timer event) - and you could just have
the OnTimer event be to run your append query.  Then you could set it
and forget it.

For your own sanity, you might want to store the information about
which mailbox to use and the password in separate custom database
properties and give the administrator a way to change these, should
the need arise.  Just saves having to dig through your code and fix
things.