Sharkfin,
Thanks for replying.
My spreadsheet creates a 'record' that has either "NameAddressStatePostcodeCountry" or "We don't have an address for you" in a single cell, where in the first situation it places an ASCII CR/LF inbetween each of NameAddress etc... through the use of CHAR(10) and then it is all exported as CSV or TSV.
If viewed in a text editor, each of those items appears on a new line. All the other spreadsheet cell contents are still separated by a comma, as in lines 1 and 3 in the example below:
Mr Yussof, Shaharin Yussof
3 Somewhere St
Hometown NSW 1234 Australia, 02 9552 1234, shaharin@mydomain.com
Thus, by definition, the 2nd and 3rd lines are interpreted as new records, even though they are bounded by the commas after Yussof and before the phone number, and therein lies is the problem.
What I'm looking for is, as you correctly stated, a way of somehow embedding a code for CR/LF into the text file that will cause PMail to produce a CR/LF when producing the mailmerge output. Maybe this explanation makes it a bit clearer. Maybe it's just in the too-hard basket, or even the impossible basket, and I will have to not be so lazy, and separate the two groups - with and without addresses - and mailmerge them separately. It's just not as elegant a solution.
Thanks again anyway, for replying.