up vote 1 down vote favorite
1
share [g+] share [fb]

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.

link|improve this question
If you are looking for VBA then you should be asking this at Stack Overflow – brettdj Jan 22 at 0:07
feedback

1 Answer

up vote 2 down vote

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.

http://mistupid.com/technical/mailmerge/

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.