Hi Everyone- I'm new to the forum, but a long time user. I've only recently starting using VB for outlook to save attachments, auto send emails etc. but i have a task that I am struggling with.

I need to send a four or five different questionnaires out to a number of people (around 100 people and each would get 1 questionnaire) to gather a wide range of information back on processes they perform. I was thinking of created a standard form in outlook with 20 input boxes and 20 labels holding the questions. Then all the recipients would have to do is press reply, select the page on the email and complete the boxes and press send.

I just need some advice. How easy is it to export the form data from the emails (preferably directly into an excel sheet). are there any rules about declaring objects that i need to be aware of before i start experimenting. I've created a form and tested sending it - filling it in and sending it back and that all works really well, its just getting the information out as a file that I'm struggling with.

I would use excel, but the variety of versions of excel used by the audience is ridiculous (some are still on 2003) and these are busy people, so i don't want them to go through the faff of saving the file down somewhere or losing it (which happens more that you'd think).

Any advice would be hugely appreciated.

Thanks

Cranston