Outlook form linked to an ACCESS table...

[bneconie]

I have created a custom form within Outlook, with tabs, tick and drop
down boxes. Users open the form within Outlook, scroll through the
various tabs and check the tick boxes and make some choices with the
drop down boxes. Then they submit the email to a general mailbox where
the email sits until I sift through it and collect the data.

What I'd like to do is setup a table within ACCESS to somehow collect
the information - automatically, or through some manual update process,
if possible.

I am familiar with creating a table within ACCESS and then walking
through the wizard to create a linked table to Exchange or an Outlook
folder (in my earlier test I choose Outlook folder and I pointed the
link to the general folder the emails currently reside). But when I
view the information through the table I created, it doesn't really
provide the extrated data collected in the custom form itself. Rather
the information in the table details the information such as:
To/From/CC/Subject.

Could I be doing something wrong? Am I trying to do something that
ACCESS really wasn't meant to do? Or, are there some additional steps
I should think about before trying to extract data between Outlook and
ACCESS - in other words import the form into EXCEL, or some other
application, and then try to import the information into ACCESS?

If there is a link available to some sort of KA or website? I'd be
happy to review it and give it a try as I think my quesiton and answers
may be lengthy in detail.

Any help would be appreciated.
thx.
bird.

 

[John Nurick]

Hi Bird,

It's quite possible to have Access monitor an Outlook mailbox for new
messages, grab them, read the contents and take action accordingly. But
it needs reasonable VBA programming skills and an understanding of the
various object models. I'm not much help because I've never used Outlook
forms.

Here are some good places to start looking:

http://www.outlookcode.com
http://www.slipstick.com
http://www.granite.ab.ca/access/email.htm

as well of course as the Microsoft Knowledgebase,
http://www.mvps.org/access and Jeff Conrad's famous Resource List at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
and the Computing section at a good bookstore.