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