Word report from Excel table

[diwakaramit]

Hello friends-

I am working on creating a word report (i have attached the word report for your reference) from an excel export from a software(i have attached excel export ). All the data on the report is coming from an excel export. An equipment id on excel sheet (Column A) can have only one row or it can have more than one row depending on number of component. For example equipment id "000000000000018192" has two rows (two components: Heatc Exchanger-Shell, Heat Exchanger-Channel). I am creating a word report for each equipment id that will have critical data fields and all the data for those fields are coming from excel sheet. I have following questions and also seeking for advice.

1. If the equipment id has only one row then the report will be 2 page report ( template attached) , but if the equipment id has two rows then that equipment id will have 4 page report (2 page per component). I really don’t know how to do this because with mail merge I am able to create 2 page report for each row but really don’t know how to create 4 page report if equipment has 2 rows. Is Mail merge still a better option or should I handle this via VBA?
2. In the word report I am doing some conditional formatting. For example, I did conditional formatting on table 4 with help from this forum. But now I need to do conditional formatting on another table (called risk matrix : See table in page 2 in word report). I need to put a circle around the number based on the vessel inspection priority number (see yellow highlight) in the word report. Can this be done with VBA?
Based on your ans if VBA is the best option then I will start working on it (may be it will take me a long time) and will definitely seek your guidance but just wanted to get your opinion before I start spending bunch of time googling and youtubing to figure out