"Alan Webb" <kn*****@hotmail.com> wrote in message
news:-s********************@comcast.com...
Daven,
Tie MS Outlook and Access together. Outlook would deliver the mail to
Access and go from there.
I've been thinking about that. I've been wondering what all is involved in
doing something like that. I've written several routines in Access that do
things like schedule an appointment, create an email, or add a to-do item to
the task list. But that is all one-way communication.
In my mind, what I see would be simply attaching a table. In Outlook, I
would then setup a filter such that any email sent to the access@ account
would go into one particular folder, and I would then be able to view (and
work with) the email in Access, on a form and also within code (since there
is parsing involved).
The ability to add a few fields to the Outlook table would be nice, too. I
would assume there's some sort of unique primary key with each record, so I
should at least be able to create a relationship with another table.
Doing this without Outlook, though, would still be nice. I have the
Developers Toolkit (or whatever they call it now-days), so I can distribute
my application royalty free. Requiring an install of Outlook, which pretty
much requires (I think) an Office install, raises the stakes a little.
Too bad I can't just attach a table in Outlook Express.
Thanks for your input.
Daven