Ask Your Question

Removing blank fields in mail merge.

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

Mikebo 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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 760 times

Last updated: Apr 09 '18