how I make multi value to one variable of string in VBA

[zalora]

Here is the original data look like
Untitled.jpg
For example the ABC Sdn BHD will become as follow.
Dear ABC Sdn BHD, We will attach the Nike, Gasbi, Panado report to you

[Mayda89]

You can simply use the

Please Login or Register  to view this content.

operator. Don't forget to encapsulate these strings in "".

[zalora]

thx for helping

[Mayda89]

your welcome