Ask Your Question

How can I create more than one record per page in "mail merge" with Writer? I am trying to make things like catalogs and fancy formatted custom labels.

asked 2017-01-08 02:17:32 +0200

Essay gravatar image

I am trying to make custom labels with very elaborate formatting and I am also working on creating various catalogs within Writer. To do this I am experimenting with "mail merge" to a table in Writer. I can get the field entered into the cells within the table.

However, I am interested in what data field I need to insert to have Writer pull the next record after printing a few cells or rows of one record in the table.

Is there an "end record" or "next record" field that I can insert into a table cell that will do the trick?

How do I get multiple data records within one page on LibreOffice Writer?

Thanks for your help with this.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-08 04:22:51 +0200

JohnD gravatar image

On the Menu --- Insert - Field - More Fields ---

In the dialog window select the Database tab and then the Type Next record and then the database table or query you want the field to refer to.

edit flag offensive delete link more


Hi John,

Thank you for your quick response. This looks like it is going to do the trick. Very cool!

All the best,


Essay gravatar imageEssay ( 2017-01-09 02:43:48 +0200 )edit

Know this is a 'little late,' but seems this is pretty much the same thing I am trying to do. Only problem is that when I select 'Next Record' and then a 'Query' there are no field names to select though the 'Insert' button is active.

When I select 'Type' 'Mail Merge Fields' the db query fields are available to be inserted into the document. This however is not the correct approach (according to this post) to print more than one record on a page.

Your assistance is greatly appreciate.

wildblue gravatar imagewildblue ( 2017-12-03 18:50:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-08 02:17:32 +0200

Seen: 6,113 times

Last updated: Jan 08 '17