Does any know how to automatically (or via a button) make information
from an Outlook e-mail populate a record in Access?

Do you mean address, name, dateofmessage ... that sort of thing? OR do you
mean info in the body of the message?

"janthony" <janthony (AT) harrahs (DOT) com> wrote

"Scott McDaniel" <scott (AT) NO___Spam--thedatabaseplace (DOT) net> wrote

Actually any and all. Most important is to grab the body of the
e-mail, but the name and date will be needed as well.

Try this site:
http://msdn.microsoft.com/library/de...lication.a sp
Jay (note:: there really is a hyphen as part of this URL
(".../en-us/vbaol10/ ...")

"janthony" <janthony (AT) harrahs (DOT) com> wrote

Hi, Jay

That's a question which interests me as well. Unfortunately the link you
sent is pretty theoretical and past my practical knowledge of how to
implement something like that. Do you know of any tutorials which might
cover the subject? I have the same need - to take emails, including body
text, and import them into an Access database.

Best regards,

L.

"LWD" <lucdix-NOSPAM (AT) NOSPAM-jam (DOT) rr.com> wrote

If you're connecting to something Access can read natively, it's about
as hard as falling down. Create "find unmatched query" and then turn
it into an append query. If Access can't read it natively, maybe you
have to use ADO...

Hi, Bradley

That sounds like a great solution, but....when I look at my Outlook Inbox, I
see no option to attach an Access table to it. How is this done?

L.

"LWD" <lucdix-NOSPAM (AT) NOSPAM-jam (DOT) rr.com> wrote

In Access select File/Get External Data/Link Tables from the menu
(Access2000). Select File Type as Outlook(). In theory you should then see a
list of the folders in Outlook (I can't seem to get it working on mine at
the moment... hmph).
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/reponse