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 dr
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
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 handl
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 in
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:
http