Importing e-mails in access (1 Viewer)

beniii

New member
Local time
Today, 12:53
Joined
Jan 22, 2010
Messages
1
Hi,
I have a database of an e-mail account with 2 tables - the first one has all the contacts/senders and the second one should have all the e-mails. how can I import e-mails into an access table?
 

ajetrumpet

Banned
Local time
Today, 05:53
Joined
Jun 22, 2007
Messages
5,638
you have to understand the Outlook library. then, you can import the body of emails into the tables once you have a memo field established. btw, this is NOT easy, unless there is a utility in 07 that you can use that is already built in. If not, you'll have to do it with code.
 

darbid

Registered User.
Local time
Today, 11:53
Joined
Jun 26, 2008
Messages
1,428
I have never done this, but I am wondering if to get you started you could first export your (assuming Outlook) information into CSV files. Then you could import your CSV files into a table.

This would get you started. If you are after a tailor made / coded VBA click of the button solution, then I am with ajetrumpet.
 

Users who are viewing this thread

Top Bottom