title: Using data from Ms-Excel to fill a pre-defined template in Ms-Word through VBA
body: <p><strong>Summary</strong>: I have to fill reports in excel and then manually copy the same in doc as required by my seniors to track bugs in different applications. The excel and doc report is different for every application. So I want to save work as I fill a excel and export it in the agreed template in word.</p>
  
  <p><strong>Problem</strong> : I am trying to write a macro which will search some variables in pre-defined template (doc) and replace these variables with data from excel. The variables are nothing but some text like &lt;-AppName->, &lt;-AppID-> (self created). Now there is a twist as there is one sheet in excel which has issues marked as high medium and low. I want to export this list to same doc as three different tables marked as high medium and low. </p>
  
  <p><strong>Question</strong>: How to populate variables (as above) in doc using the data from excel via VBA? If at all I can populate variables how do I manage to export the data from excel to doc in three different tables since it will have multiple lines.</p>
  
  <p><em>Thanks in advance.</em></p>