Hi all,
I am new to macro development.
Need to confirm whether Macro can do the task or not:
I want to create a survey form.
1) Create a form using excel.
2) Send the form to person1 via email by person2
3) Mandatory fields of the form must be fill in by the person1.(the form will ask him to fill in all the mandatory fields)
4) After clicking the submit button by the person1, response need to comeback to the person2 who sent.
5) After received the response, need to send response to the person1 who filled the form.(like thanks or error like mandatory fields are missing like this)
Is it possible via macro and excel? If yes please advice how?
- Is it possible to send all the email clients(like outlook, gmail, hotmail etc..)
- Is the form receive in the same format to the person?
- Is it expensive to develop?
Thanks
Shaan
I am new to macro development.
Need to confirm whether Macro can do the task or not:
I want to create a survey form.
1) Create a form using excel.
2) Send the form to person1 via email by person2
3) Mandatory fields of the form must be fill in by the person1.(the form will ask him to fill in all the mandatory fields)
4) After clicking the submit button by the person1, response need to comeback to the person2 who sent.
5) After received the response, need to send response to the person1 who filled the form.(like thanks or error like mandatory fields are missing like this)
Is it possible via macro and excel? If yes please advice how?
- Is it possible to send all the email clients(like outlook, gmail, hotmail etc..)
- Is the form receive in the same format to the person?
- Is it expensive to develop?
Thanks
Shaan