Wkipedia english does not mention libre/openoffice in "Mail merge" at all, the german Version at least openoffice for "Serienbrief". Could someone more apt than I make an addendum? Have a good tiem with LO Walther Am Sonntag, 15. August 2021 schrieb Michael H:
(unrelated to your last comment.) I looked in the latest Writer manual, and there is no "updating the source" instruction for mail merge chapter. Considering "open Base first" is not exactly intuitive for making changes in Calc and seeing them in Writer... it possibly might be very helpful to somehow capture this in the next version of the Writer manual. (Related to your last comments) When changes in Calc directly didn't show up in the data table view in Writer, I had tried 'refreshing' in Base many times before this email, and expected the table view to show my new #1 item either at the top or bottom of the base table. Following the steps I listed, "Rebuild" shows the new column and the new data in Base, and that data also now shows in the Writer data preview table. I was noticing that when I edited the calc file, it seemed to break the link in Writer and suddenly preview didn't work. It took exiting LibreOffice completely then restarting writer before the data table links again, but it always matched the table view in Base, not my new data in Calc. I associated this (unproven) with Linux swap management or something similar, but I've really got no understanding why my system (ubuntu based) has a latency between updates in calc and views in Writer merge data preview, only that saving and quitting the program completely seems to eliminate the lack of cross-updates. On Sun, Aug 15, 2021 at 12:44 PM Robert Großkopf <robert@familiegrosskopf.de> wrote:Hi Michael,But for anyone else following, here's the slightly amended suggestion: 1. Open the Base file used by the Writer merge file 2. (With Base still open, but not as an action from within Base, justusinga file manager) Open the source Calc file, Make your edits and save.You don't need to save them at this moment. Rows, which appear in the table of Base, will be changed by "Refresh" in the table (Data → Refresh). New Rows won't appear directly in the table. Close the table and go to View → Refresh Tables. Now new Rows will be shown.3. With Base still open, open the table related to the merge, and on the toolbar select "rebuild". 4. Save the Base file.Also you don't need to save the Base file. Nothing has been changed. Base file will only connect from Calc to Writer. Or did there appear the littel star in the Save symbol?4A. Close all LibreOffice files. (**) 5. Open the Writer merge file, and your changes should be present. (**) --- I use a Linux OS ... I've found that this close all office files step is required in Linux, but not always in Windows. Or morespecifically,I find that when I follow youtube videos about LibreOffice made from Windows, including 'close all Libreoffice' as a step after making updates elsewhere seems to make stuff work that just doesn't work for me like it does in the video.I'm using Linux (OpenSUSE 15.2) also. I haven't closed any file for this. You only have t press "Refresh" for the table of the database in the database browser of Writer. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Diese Nachricht wurde mit Freier Software gesendet: http://fsfe.org PGP Schlüsselkennung 09A9C5C0195A8998 Ich bevorzuge reine Textnachrichten, html bedeutet erhöhten Traffic und Energieverbrauch, vermehrten Speicherbedarf lokal und hat Sicherheitsrisiken. -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy