Re: [libreoffice-users] Re: Conditional Whitespace for Mail Merge

2015-02-12 Thread Sven Schüring
Hi Andreas, thanks for your reply. I've a Calc-Sheet with address data (linked with Writer it was transformed to a database). In my used Writer (LO 4.4) the query does no work properly. The query described by you would be in my case [my calc sheet].members.title != but only [title] != is

[libreoffice-users] Re: Conditional Whitespace for Mail Merge

2015-02-12 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Conditional Whitespace for Mail Merge

2015-02-12 Thread Sven Schüring
Hi Andreas, thank you for your effort. :) I got the fail. Our concluded condition is working correctly. Field type - Conditional Text Condition: [Titel] != Then: Else: Now the big BUT! If I click me through the mail merge assistant I got a document preview where I can scroll through the

[libreoffice-users] Re: Conditional Whitespace for Mail Merge

2015-02-12 Thread Andreas Säger
That wizard is counter productive and irritating for several reasons. You can create serial letters easier without it. Once you have a registered database connection to your list (F4 shows your database and tables), all you need to do is this: Select your table or query in the left pane and then

[libreoffice-users] Re: Conditional Whitespace for Mail Merge

2015-02-11 Thread Andreas Säger
Composing the lines of an addressing area is easy to do with a query. Details depend on the type of your database. In Writer you can use a conditional field with a nested data source field like this: If condition: DataSource.QueryName.Title != Then: -- View this message in context: