|
Home > Archive > MS Access Database with External Data > April 2006 > Accessing Outlook PST file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Accessing Outlook PST file
|
|
| Roger Lord 2006-04-03, 3:33 am |
| I am trying to develop an Access program that can read Outlook
emails from a folder in a .pst file, decode the text information
in the body of the email, and then move the processed email into
another folder in the same .pst file. Is this possible?
The purpose of this program is to allow remote users on the other
side of a firewall to request work to be done via Outlook email.
All emails will have the same Subject line. The Access program
will open the email, grab all text lines in the email, convert it
to field data, append the data to a table, and then move the
processed email to another folder so that it won't be read again.
Thanks,
Roger
| |
| david epsom dot com dot au 2006-04-03, 3:33 am |
| You can link to tables using the Outlook or Exchange
table types (both of which are actually MAPI).
(david)
"Roger Lord" <Roger.Lord@removethis.cox.net> wrote in message
news:8e%Xf.9693$FD4.1136@dukeread07...
>I am trying to develop an Access program that can read Outlook
> emails from a folder in a .pst file, decode the text information
> in the body of the email, and then move the processed email into
> another folder in the same .pst file. Is this possible?
>
> The purpose of this program is to allow remote users on the other
> side of a firewall to request work to be done via Outlook email.
> All emails will have the same Subject line. The Access program
> will open the email, grab all text lines in the email, convert it
> to field data, append the data to a table, and then move the
> processed email to another folder so that it won't be read again.
>
> Thanks,
> Roger
>
>
| |
| John Nurick 2006-04-03, 3:33 am |
| Hi Roger,
It's possible but I wouldn't call it easy and don't know exactly how to
set about the .pst end of it. Probably the best place to start is at
www.outlookcode.com and/or www.slipstick.com.
On Sun, 2 Apr 2006 21:53:05 -0400, "Roger Lord"
<Roger.Lord@removethis.cox.net> wrote:
>
>I am trying to develop an Access program that can read Outlook
>emails from a folder in a .pst file, decode the text information
>in the body of the email, and then move the processed email into
>another folder in the same .pst file. Is this possible?
>
>The purpose of this program is to allow remote users on the other
>side of a firewall to request work to be done via Outlook email.
>All emails will have the same Subject line. The Access program
>will open the email, grab all text lines in the email, convert it
>to field data, append the data to a table, and then move the
>processed email to another folder so that it won't be read again.
>
>Thanks,
>Roger
>
>
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|
|
|
|
|