Copy outlook mail body to Excel - to workout Quiz results

[premvinoth]

Hi,

We regularly conduct Quiz among our team of 50 members. A email from outlook will be sent out to the group and once we get the reply with answers, we would manually copy the email body to Excel and then run a vba macro that checks for marked answers and captures the result on another sheet.

Is there any simple way to automate it through VBA.

Thanks in advance.

Regards,
Prem