You just need to investigate why the code is working for your first case?
In in the required format itself, for the first case All the items are listed with a semicolon and in second its with a return character.
use vbcrlf instead of ';' in your code.
In in the required format itself, for the first case All the items are listed with a semicolon and in second its with a return character.
use vbcrlf instead of ';' in your code.