Thank you very much SamT for your input.

This has at least given me some idea and glimmer of hope that it is possible, and will have to look at Outlook integration at a later stage.

With regards to response received, ideally I'd like it to update the master worksheet (table 1 in doc previously attached ) and reflect the responses there.

This form would than be used on an half yearly basis to update the records as needed. What do you suggest is the best way of capturing/storing the reponses in the master spreadsheet?