So it's a Calc sheet actually. I would simply use Calc to concatenate the proper field contents and then use that calculated field for the mail merge. Something like =TRIM($A2&" "&$B2&" "&$C2) with a column title in the firs row copied down along the list. A database query would be easier to handle because it automatically applies to the whole record set: Something like: SELECT LTRIM(CONCAT("Title",CONCAT(' ',CONCAT("ForeName",CONCAT(' ',"LastName"))))) AS "Full Name", <other fields> FROM "Sheet1" This looks horrible because there is only a very limited set of functions when you mis-use a spreadsheet for a database connection. But with the right double-quoted names of sheets and columns it will generate a calculated "Full Name" field on the fly. Availlable SQL-functions with file based data sources <http://www.openoffice.org/dba/specifications/file_based_functions.html> Doing this in the last element of the chain is difficult. The only resource I know is http://openoffice.blogs.com/openoffice/2007/05/suppressing_bla.html describing a solution for a similar problem. -- View this message in context: http://nabble.documentfoundation.org/Conditional-Whitespace-for-Mail-Merge-tp4139674p4139885.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted