Importing emails into access.

[primed]

Hi, I have created a linked table from access 07 to my inbox in outlook 07.
The data that is imported into access doesnt contain any attached files. How
do i either import the file aswell or automatically create a link from the
imported data back to the email so i can get to the files.

Thanks in advance.

 

[David C. Holley]

What exactly are you wanting to do? Why need to pull the emails into Access?

 

[primed]

I use issue/correspondance tracking on access. Information comes via
fax/phone and email so i am trying to store all the information in the one
spot for easy tracking.

I would like an access table that contains the header, the contents, time
received, person who sent it and the attachments of the emails received in my
projects inbox.


Regards

 

[David C. Holley]

So the Journal in Outlook isn't an option?

I use issue/correspondance tracking on access. Information comes via
fax/phone and email so i am trying to store all the information in the one
spot for easy tracking.

I would like an access table that contains the header, the contents, time
received, person who sent it and the attachments of the emails received in
my
projects inbox.


Regards

 

[primed]

Hi David,

Hadn't used the journal in outlook before. Just had a quick look. The issue
would be that I would have to customize outlook to be able to use all the
other information that I store in access. Things like being able to see all
the stores that one client owns and being able to easily see all the
correspondance from 10 different suppliers for the one store.

With access I can customise every form to suit the way i work. So i think i
need to stick with access unless there is a way to import access forms into
outlook.

Appreciate your time.

 

[David C. Holley]

This should get you started...

http://blogs.techrepublic.com.com/howdoi/?p=119&tag=content;leftCol

It was written from the stand point of sending emails from Outlook to
Access, however it shouldn't be too difficult to adapt it to run within
Access where you're pulling the email out of Outlook.

 

[David C. Holley]

Side note - You may want to consider running it from within Outlook as you
would then be able to set it up to run when you receive new mail. You'd have
to create UserForm to prompt the user as to which client the email belongs
to, but that would also be fairly simple.

To populate a combo box on a Microsoft Outlook form
http://www.outlookcode.com/d/code/popcombobox.htm

Automate Outlook from Access (the other side of the equation)
http://www.blueclaw-db.com/read_email_access_outlook.htm

 

[David C. Holley]

Side note - You may want to consider running it from within Outlook as you
would then be able to set it up to run when you receive new mail. You'd
have to create UserForm to prompt the user as to which client the email
belongs to, but that would also be fairly simple.

My bad - wrong article. Let me look around for an example.