|
I have a questionnaire that users complete. It is in Excel. After users complete the questionnaire I would like to be able to generate a Word document that contains their answers. For example "The answer to your question was [answer from Excel Questionnaire cell A49 ]" I have seen that this is possible with Sharepoint. However, I don't have Sharepoint. I am working on MS Office 2010. I also have visual Studio Express 2010. What is the best way to achieve the above, pretty please? Thanks. |
|||
|
|
Perhaps use the mail merge feature in MS Word? It wasn't originally designed for this, but you should be able to get exactly the results you need. |
|||
|
|
|
You may be long beyond this problem, but here are links towards a solution. This covers a range of options. Essentially, from Word 2010 use the Insert > Object button. Choose your Excel spreadsheet and then choose the range you want to select. I am new to this process as well so I can't offer any advice about fine-tuning the formatting, but that should get you started on importing data from Excel. |
||||
|
|
