VBA to take from excel list and populate word template

Hi all,

I am going to need to find the syntax for vba that takes a list of examples from excel cells and inputs them into the corresponding places within a word template.

So in word i have a table somewhat like this :
Pricing Transparency Examples
PROCEDURE LOCATION1 Market Analysis

Location Rate Rate Type
[HIGH COST PROVIDER1] $ [CASE/ %]
[MIDDLE COST PROVIDER1] $ [CASE/ %]
[LOW COST PROVIDER1] $ [CASE/ %]

*Total Savings of $[SAVINGS1] could be achieved between high cost and low cost service providers.

and in excel i would have a list like:

Colonoscopy Little Rock, AR
Baylor 2000
Medical Center 1500
Endoscopy Center of Dallas 500

and so forth
So i would like to know how can i make a template in excel that will identify the first procedure in a list (colonoscopy),
fill that into Procedure1, the city into Location1, etc.

I would love to learn the syntax so that I can apply this to other types of reports I normally have to transcribe over to word.

Thank you very much for your help!

thebkap,

I have a routine that does this from Excel to Word Template, not .doc.

Can you provide the xlsx file and the template to look at.

cplmckenzie

Unfortunately I cannot provide an actual example due to company rules/healthcare laws.... which has made this challenge of innovating this process extremely difficult.