Ask Your Question
0

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
1

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

Ratslinger gravatar image

Hello,

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

edit flag offensive delete link more

Comments

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
1

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

pierre-yves samyn gravatar image

Hi

Short video (english subtitles).

Regards

edit flag offensive delete link more

Comments

Merci! Very helpful.

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

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
0

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

Stats

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

Seen: 1,429 times

Last updated: Apr 09 '18