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.