Hello VBA masters,

I'm tryin to find a solution how to cllect data from many users efficiently.
Regullary I have to ask round 50 users and they reply by E-mail. I want to
process their responds automatically in an excel file and track who has
replied and who not.

I was thinking about some forms that would contain fields where the
recipient can type the answer and send.

The question is if this is possibble at all and if yes, what is the best
solution. Forms or VBA?

Has someone st. like a template or framework I could inspire myself an begin
with?

Thank you in advance

Martin