My school district is moving from Google Apps to Office 365 and I am trying to find out if Office 365 will be able to accomplish a task.
In Google forms I created a survey and after someone completed the survey a "script" was automatically run and it would take the responses and place it into specific places in a template and then it would convert it to a PDF and email me the completed form.
I have looked at the "Surveys" in Office 365 and can easily create a survey and get the results in excel. I know I could then take the results and go into Word and create a template and then do a Mail Merge, but I am trying to automate the process.
Does anyone know if this is possible with some type of Script or Macro in Excel in Office 365?
In Google forms I created a survey and after someone completed the survey a "script" was automatically run and it would take the responses and place it into specific places in a template and then it would convert it to a PDF and email me the completed form.
I have looked at the "Surveys" in Office 365 and can easily create a survey and get the results in excel. I know I could then take the results and go into Word and create a template and then do a Mail Merge, but I am trying to automate the process.
Does anyone know if this is possible with some type of Script or Macro in Excel in Office 365?
