Importing Data From Outlook

[krwyth]

I would like to automatically import catalog requests I receive via Ourlook email into an access table.

Anyone know of a simple way to do this?


I have been doing this manually for the last 3000 records and its getting old

TIA


PS I receive the data in this format:

Name: Sharleen Smith
Address 1: 225 Fake Blvd
Address 2:
City: Boca Raton
State: FL
Zip: 33430

Email: stfake@notreal.net
Phone:

Heard about Us: friend:
Products interested in: all

 

[krwyth]

bump. anyone?

 

[BennyWong]

bump, bump Me too!

 

[at51178]

well if you go to the tables section
and you right click you will pick link tables then in the file types you will choose either exchange or outlook which ever one will help you. then you just pick the folder that you want to link.

Let me know if this of any help to you

 

[ApplePirate]

tried this method and doesnt seem to work, it allows me to browse the folders, but doesnt allow me to view the contents. does anyone have any ideas as to how to import e-mail attachments.

Never ever, bloody anything, ever

 

[Rick39]

Never tried it, but this might help:

http://www.mvps.org/access/modules/mdl0018.htm