How to create MS Word document automatically with Dynamic fields

krishtalk.com/

Excel text manipulation
krishtalk.com/2018/10/practical-text-manipulati…

Useful Tips on Office Automation

How to create ms word templates

This video shows how to create a template in MS Word using Quick parts, Fields, Bookmarks and VBA macros. Templates are useful for automating word documents. You can store repetitive values somewhere in the bookmark and place them wherever needed.


Download the example here

krishtalk.com/2015/05/how-to-create-template-in…

There are 3 steps to create MS word templates.

Step 1

Create a section of bookmarks, which hold the value you enter. These are hidden.

Step 2
Create field code to populate the values. Use ASK filed to get the values from user and store them in the bookmarks created earlier.

Step 3

Create fields where you want to place the values stored in bookmarks. use the FORMULA field to get the value from bookmark and place them wherever you want
code REF Bookmark name

Finally you can create a macro to update all the values. For this you can create a button and assign the code to it.

code
Private Sub Update_Click()
Fields.Update
End Sub

Subscribe to my channel:
youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: youtube.com/krishnayess
My Blog: krishtalk.com/
Google Plus: plus.google.com/+KrishSanj/
Twitter @iTwittt
twitter.com/iTwittt