I have a merge field in a tab delimited csv file that is of the format ["element 1", "element2"] from 0 to 12 elements.



The csv file produced by a custom application (written in Swift on Mac) could be modified but not easy.

The mail merge needs to display the elements of the filed one per line but only if the field exists.

The merge document uses the csv file as its data source and the merge will ideally be triggered from the Mac application, possibly via a script but thats just a nice to have.

I believe that this can be done by the built in VB, worked out how to get the value from the merge fields but no idea how to get the result from the function into the merge output. Assuming I need a field of some kind but thats were even my ability to google fails to find a clue.

I have not used VB since version 3 too many moons ago to even remember!

Not even sure I am going about this the right way. Client will be upgrading to Office 365 if I can get this too work as Pages on the Mac is . . . .

Any suggestions / ideas much apricated.

Ian