Can a Word 2010 document be used to gather information and create
documents based on the input?
Here is the problem I am trying to solve, and my question is, "Can this be
done in MS Word 2010?"
MS Word 2010 form is given to user
User returns form to me, completely filled out
Based on the information collected, 3 different documents are
automatically generated via me clicking a button on the form.
The documents that management wants me to generate are:
A proposal, which basically amounts to a giant form letter where a bunch
of text will always be the same, and certain sentences/paragraphs/tables
will need to be altered based on the response provided by the user.
An Excel spreadsheet, with certain cells populated by the content found in
the Word form
A form letter, which again picks and pulls certain pieces of content from
the original form the the user filled out.
I'm pretty familiar with VBA in terms of creating a form and clicking a
button which attaches the form to an MS Outlook email, but I'm less
familiar as to whether Word can generate other documents on its own based
on certain content found within.
Wondering if anyone's done this already and could provide an example so I
don't have to re-invent the wheel.