Email, Forms, Automatic Update.....Any Ideas??

[dearing]

Hello

I really need some help. I have an idea that this can be done, but I don't have the knowledge, expertise, brain power etc - that most people have - like yourself reading this.......(creep eh?).

1. I have a form created in Access that needs to be sent via email to 'loads' of people to be filled in
2. The completed form is then returned to me again via the email.
3. I need the information recieved to update the main database automatically.

It sounds simple??

Does anyone know if and how I can do this???????

 

[danvlas]

I'd do this with Excel worksheets sent to 'loads' of people.
Protect the worksheets in such a way that recipients can modify just what needs to be modified.
Then use Outlook as email client, set a rule for replies to come into a special MAPI folder, then Automation to get the attachments from email messages and import data from the filled in Excel sheets into the relevant table.

Access forms are database objects, so forget about sending them.

Regards

Daniel Vlas
Systems Consultant
danvlas@yahoo.com