Ask Your Question

Removing blank fields in mail merge. [closed]

asked 2018-04-07 23:22:04 +0200

Mikebo gravatar image

updated 2020-08-30 23:59:39 +0200

Alex Kemp gravatar image

I'm trying to create address labels from a spreadsheet. I have managed to do so, but some addresses are shorter than others, ie there is an empty field, which shows as a blank line in the middle of the address. Is there any way of ignoring blank fields so that I don't have blank lines on the labels.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-30 23:59:50.044152

4 Answers

Sort by » oldest newest most voted

answered 2018-04-07 23:31:45 +0200

Ratslinger gravatar image


Please see Writer documentation Chapter 14, Mail Merge page 14 -> LibreOffice Writer Guide.

edit flag offensive delete link more


Along with the French YouTube video, I have succeeded in 'suppressing paragraphs', although I wouldn't have known it was called that at the start of this process! Thank you.

Mikebo gravatar imageMikebo ( 2018-04-09 10:46:52 +0200 )edit

answered 2018-04-08 07:34:03 +0200

pierre-yves samyn gravatar image


Short video (english subtitles).


edit flag offensive delete link more


Merci! Very helpful.

Mikebo gravatar imageMikebo ( 2018-04-09 10:44:41 +0200 )edit

answered 2018-04-09 10:47:33 +0200

Mikebo gravatar image

All fixed now. Thank you for your responses.

edit flag offensive delete link more

answered 2018-04-07 23:32:17 +0200

Use a Hidden Paragraph field (Insert-Field-More Fields...-Functions), or a section (Insert-Section). In both, you may define a condition to hide. See Defining Conditions to hide when a field is empty.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-04-07 23:22:04 +0200

Seen: 1,647 times

Last updated: Apr 09 '18