Dear Everyone!

This is my problem:

I have cell1, cell2, cell3 and cell4.

In cell5 I use CONCATENATE to bring the content of cells1-4 in one text and it is working.

I want to use the content of cell5 as part of an email body with an outlook email automation but whenever I run the tests, only the content of cell1 appears in the body of the produced email.

Remark: these text are long long strings.

Anyone has any kind of solution or idea for this issue?

I tried CONCATENATE, I tried “&” I get the same results:

In cell5 everything appears as it should. In the email only the content of cell1 appears.

I even created the test where I added cell1 cell2 cell3 cell4 in the body of the email and the result is the same.

I have alot of columns and these are the last 5 columns of my table.

Thank you for all the help.

-A