Macro for transferring cell components to Word

[mdar007]

Objectives:
1. Transfer cell components of column B to F in Excel to a designated place in Word
2. Must retain the format of the destination
3. Repeat the process a number of times equal to the number of rows after row 7 (I think the way to do this is to manually input a value in a separate cell and make it as a base of the macro like, i = 0 to H1 where H1 is the number of rows after row 7)


For example:
I need to transfer cell B8 to Word in Bold format and then cell C8 after that in a regular font upto F8 then repeat that for B9 with Bold format then C9 again etc.


The excel table is arranged as follows:
Column B represents the Diagnosis
Column C represents the Detailed explanation of the diagnosis
Column D represents the recommendation in what to do




I am thinking of using a find and replace macro like:


Find B8 in word then replace with range B8 from excel
Repeat with offset + 1 (e.g. range B 9)
Number of loops = value in H1


'then repeat that with other cell values.

I am sorry, I am not well versed in vba but I have experience in making simple macros as long as I understand the logic behind the code. I really have a problem with loops though.

 

[Macropod]

Ambiguity aside, your description suggests it's something you might be able to use a mailmerge for.

 

[mdar007]

Thank you for the fast reply! Ok. Will check mail merge. But if I need to further explain my problem I can add more info.

Basically, I just need to do this:

From this
https://i.imgur.com/Ne0xNFG.jpg

To this with same format
https://i.imgur.com/lhIE7pP.jpg

 

[mdar007]

Thanks! Mail Merge really is what I want.

 

[Macropod]

From what your links disclose, that is certainly something a mailmerge can handle.