How to collect data via an e-mailed form ?

[biggles]

I have a golf society database. I would like to be able to send, via e-mail, a 'Form' to each of the members of the society so that that they could fill in the data in the form then e-mail it back to me and then import it into the database.

Has anyone got any good suggestions on how I should do this please ?

Cheers
Frank

 

[boblarson]

Which version of Access are you using? Access 2007 and Outlook 2007 have this sort of functionality built-in. But other versions are going to be problematic.

 

[biggles]

I am using Access 2007 and Outlook 2007 with Vista.

have tried that feature and its quite neat, but the 'form' that is generated out of access is quite restricted, you can't really add text to help describe the data required in each field.
I was hoping to use something like a word form but you think that may be problematic ?

Thanks for your support.

Frank Wilson......with 4 inches of snow here today already !!!

 

[boblarson]

It requires quite a lot of code to be able to do something of that nature, otherwise.