Use Outlook, compile teams' status reports into 1 summary report?

[Guest]

We use Outlook 2003 for Emailing and meeting management.
We have 5 teams, each with 10 members.
I want to:
1. Email/prompting each member to complete a Weekly Status Report form.
2. Automatically collect members' responses/results
3. Parse the data from form fields into a Management Summary with categories:
a. Priority (High, Med, Low)
b. Due Date
c. Team Name
d. Member Name
e. Task Name
f. Task Risk/Opportunity description

I seem to recall that something like this is possible with Lotus Notes.
However, I want to use Outlook (and, maybe, Access 2003). I have programming
experience w/ C++ and have used MS Access to create simple DBs and reports.
Assistance/Guidance appreciated!

 

[Roady [MVP]]

You can achieve this by using custom forms and some VBA code but you might
be better off hosting this directly on your companies intranet site instead
of using emails for this. This way you can feed the database directly and
you are much more flexible with running queries and applying updates.