Retrieving Outlook Message Text

[Rich Locus]

Access Group:

I would like to be able to read the text from a select Email Address in
Outlook and insert the message text into a Memo field.

I can think of two ways to accomplish this:
1) Have outlook create a text version of the message in a defined directory
each time an email is received in that account. I will then have Access look
for any new files (DIR command) and then read the text file, insert the text
into a MEMO field, and I'm good to go.

2) Include the Outlook library in References, and then use Outlooks's VBA
specific objects to read a specific account's email. When I retrieve the
message, then I will use Access's objects to copy the text and insert it into
the database.

Is anyone familiar with either approach 1 or 2?

Thanks,

 

[Tom van Stiphout]

On Wed, 5 May 2010 17:54:01 -0700, Rich Locus

I have successfully used #2. You can "listen" for Outlook events
(using the WithEvents keyword) and for example be notified when any
email shows up in the Inbox. You can then check it out, decide if you
need to process it, and if yes do your thing.

#1 seems a bit archaeic with #2 available.

-Tom.
Microsoft Access MVP

 

[Rich Locus]

Tom:
Do you have any snippets of code?
Thanks,
Rich

 

[Tom van Stiphout]

On Wed, 5 May 2010 21:05:01 -0700, Rich Locus

Here is a starting point:
http://support.microsoft.com/kb/292063
http://msdn.microsoft.com/en-us/library/aa171270(office.11).aspx

-Tom.
Microsoft Access MVP