Ask Your Question

In Mail Merge, how can I conditionally select the records to be processed?

asked 2016-05-19 10:55:12 +0200

Jean-Paul gravatar image

I am using mail merge in LibreOffice, with a form letter in Writer and a "database" in Calc.

When printing the form letter, the only options I get are : printing all, printing a manually selected list, or printing a range based on record number.

I want to conditionally select the records of the spreadsheet to be processed in the mail merge, based on specific values of a column in the spreadsheet. How can I do this ?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-05-19 11:43:28 +0200

pierre-yves samyn gravatar image


When printing with FilePrintYour document contains address..., answer Yes.

Mail merge dialog opens in which you have filter tools (autofilter, standard...):



edit flag offensive delete link more


Oh yes ! I overlooked this possibility. I just tested it and it works greatly. Thanks for your quick and efficient support.

Jean-Paul gravatar imageJean-Paul ( 2016-05-19 14:06:35 +0200 )edit

answered 2018-07-17 14:52:09 +0200

floeschie gravatar image

Is this available on Windows only? I can't see the filter icons on Fedora Linux (LibreOffice Version: Build ID:

edit flag offensive delete link more


Hi @floeschie

All I have on hand now is a debian jessie with Libo 4.3 and the feature is available... I can not say more, sorry.

EDIT Just verified ok on jessie with Libo


pierre-yves samyn gravatar imagepierre-yves samyn ( 2018-07-17 15:22:19 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-19 10:55:12 +0200

Seen: 626 times

Last updated: Jul 17 '18