VBA - Fill out Term Sheet Word Document From Excel Ranges

[PHayes35]

Hey Guys,

I have a term sheet template in the form of a word document, as well as an excel worksheet that contains all the information necessary to fill out the term sheet. I created a bookmark for each range I needed to fill out in the word document, and I also named each range in excel by the same name as the bookmark. I'd like to write code that fills out the term sheet based on the information in the excel range's, and then saves that term sheet as a new document. The ranges contain language like:

$586,735.00, (4.30% of the Notional Amount) will be paid by Party A to Party B", as well as %'s and Dates.

<tbody>
</tbody>

I'm very new to VBA, and have struggled finding/writing code that allows me to do this. Any direction I can be pointed in would be much appreciated.

Thanks!

 

[mrhstn]

Hi

Would you not be better using mail merge in Word for this?

 

[Macropod]

See: https://support.office.com/en-us/ar...nvelopes-f488ed5b-b849-4c11-9cff-932c49474705