VBA to Populate text content controls in word from excel

[lmoir87]

Hi

I am trying to populate a word document with named ranges/cells in an excel template.

My first iteration was using 'Label' and i was able to get these to populate as follows;

ThisDocument.Label1.Caption=workbook.Sheets("Sheet1").Range("Label1)

However, I would prefer to use a Rich Text content control, so that the formatting matches the document and so it is possible to click into the content control after it has been populated.

Thanks
LM