Thread: Excel to Populate Word Form Fields & Document

I have two word form documents and a letter that I need populated with the same basic data. The forms are secured, with only the form fields (text, dates, checkboxes) fillable. The document is open.

I need to find a way to pull the info from a single source xls file and populate both forms' fields and the word document. I can probably do this via bookmarks; however, I have to admit that I'm not sure how.

I'm not even sure if I will have to use vba to do it. But any help would be greatly appreciated.

I think I can do that; however, I should clarify that multiple users will be doing this, and I'm trying to arrange a one click possibility for them.

Also, I should state that there should be an option to populate one of the Word forms, as the second one is not always necessary.