Importing an Outlook folder DIRECTLY into Access table

[44macfan]

I am trying to import a group of emails from a survey into an Access table. I can do it using Outlook's export to text (windows) feature, but that makes for a tedious process that some of my users may not be able to do. The email also comes in with all of the email junk (ie tomail, frommail, and body tags).

Is there a direct method to do this?
Is there an easy way to omit the Email tags?

All of the emails in the folder are formatted as follows;

unique_key (tab) answer_1
unique_key (tab) answer_2
unique_key (tab) answer_3
etc. etc.

Thanks in advance for your help.

 

[tlbroadbent]

If you have Access 97 or later, you can use the Import Exchange/Outlook Wizard to import a mail folder (Inbox or other) to Access. You can also use the Link Exchange/Outlook Wizard to Link a mail folder to Access. Perhaps you ould then write code to extract the data from the Email messages and update the appropriate tables. Of course, all surveys should be mailed to the same email address. Terry

http://members.home.net/tlbroadbent/index.htm

 

[44macfan]

thanks Terry

I guess I neglected to mention that i had tried to export to access using the wizard. I does not keep the tab delimitted fields aligned properly. It places them all in one field.

CG

 

[tlbroadbent]

I understand that upon import the message of the Email is put into one MEMO filed. However, when I link the mail folder the tabs still remain in the message. You would simply need to write some VBA code parse each message. Terry

http://members.home.net/tlbroadbent/index.htm

 

[djnick]

hi .. i am a very novice user and looking to do the same with my first database get stuff of a email form which is recieved by outlook..

did u mange to do this could you send or show me an example and explain how to achieve this..

many thanks

nick calladine