We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How can I update my mail merge / serial document data source?

asked 2019-01-26 22:39:14 +0200

baziliscus gravatar image

updated 2020-07-11 23:42:46 +0200

Alex Kemp gravatar image

I prepared a Calc spreadsheet detailing my students' exam results and averaged grades.

I would like to print a slip of paper for each student listing their results.

I set up a Writer document and followed these steps: https://jb-blog.readthedocs.io/en/lat... to use my spreadsheet as a database. This worked fine.

I later spotted a few small errors in the original spreadsheet, so I updated and saved the spreadsheet. I thought I could just hit the Refresh/Rebuild button in the Writer toolbar to read the fixed data into Writer but that doesn't seem to work; the updated numbers only appeared in the Writer document after I essentially started over by going back to the Writer menu Edit > Exchange Database..., re-selecting the spreadsheet, and dragging the relevant fields into the Writer document again.

Is there a more elegant way to do this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-01-28 00:10:23 +0200

Ratslinger gravatar image

updated 2019-01-28 00:32:56 +0200


Have spent a bit of time with this and fail to duplicate your problem. Using LO v6.1.4.2 on Mint 18.3, here is what I did:

  • Open a new Writer doc

  • From menu Edit->Exchange Database...

  • Searched for Calc file, selected wanted sheet, clicked Define then Close; Never have to do again

  • Created document wording and inserted fields using Data Source from newly registered sheet.

  • Performed mail merge; all records OK

  • Saved document then closed it

  • Changed Calc data, saved & closed

  • Open saved Writer Doc; first record had old data but after scrolling past first record, all were displayed with updated data including the first one when scrolled back to; could also see all as updated when Edit Individual Documents was selected.

Based on your comment about re-doing Exchange Database, it appears something wasn't saved or selected during your process as the Calc sheet was available to other Writer documents since you only need to register it once.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-26 22:39:14 +0200

Seen: 1,903 times

Last updated: Jan 28 '19