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

Unless you can publish a custom Outlook form to the Organizational Forms
library on your Exchange server, a custom Outlook form is not a viable
solution for data gathering. Consider using Microsoft InfoPath, a web page,
or a survey generated by Access 2007+Outlook 2007.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Martin" wrote in message
...
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