Combining Text and data from a table in excel

Hi All,

I have a task which requires me to follow up exception events that occur each day. This involves hundreds of exceptions, the information of which comes from a report.

Thanks to help wonderful help from Sergei, and this community using Power Query i am able to break down the report into a useable table of data. I have also found a macro which can send emails from excel by populating outlook emails with the contents of a cell.

As such i am looking to combine a set message for each exception, with the relevant data from my data table. To complete i trying to use some "Text" and links to the data table in Column I. I have tried using CONCATENATE, however it doesn't seem to read the cell references. I am trying to customize the message for each exception in column L, with the data for each exception event.

Can someone please assist in showing how i can link my data table with my message.

Thank you kindly for any assistance.