Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a requirement which asks for filling the details into a word doc with a predefined template from SharePoint site and then the word doc should be automatically saved when clicked on saved button.

  1. Need to understand whether can fill in a predefined word template from Sharepoint site
  2. Can it be acheieved from list or library , say filling the list details and save after finish should reflect in word doc with a predefined template
  3. I want that filled doc to be saved in SharePoint site itself.
  4. All the above steps possible,if so what tools should I use

Any ideas are highly appreciated.

Thanks T Kartheek

share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

This is very possible using the following:

  • A Document Content Type holding all the fields you want to have appear in your document
  • A Template library that holds your document template and is using the above content type
  • A second document library that will have the above content type and has the template document above as its document template (advanced settings under Document Library Settings - Content Type Name)
  • A custom list that has the same fields as those used in your content type.
  • A SharePoint Designer workflow that will run on the creation of an item in your custom list above.

Once you upload your template to the template library, open the template from SharePoint and in Word (assuming 2013 but could be 2010 also) and go to Insert -> QuickParts -> Document Property. You should see the other content type fields appear here. Add them to the document and save it back to SharePoint when ready.

In the second document library add the same content type and make sure that it's template refers to the template document you uploaded above.

In SharePoint designer, create a workflow that will run against the custom list you will create. The workflow only needs to do one thing, create a new item in the secondary library above.

In the workflow action, make sure you specify the correct content type, and you map the fields from your custom list to the related content type fields. Ensure the workflow will run on the creation of an item.

Then whenever a user adds an item to your custom list, the workflow will fire and create a new document in your secondary document library. It will also copy the custom item values that the user entered to the secondary document library.

When a user opens the new document it will pull those values in as per your template.

I hope this helps, I know it is a bit convoluted but I wanted to show you how you can do this more or less out of the box.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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