Re: [libreoffice-users] Update a mailmerge file

2021-08-16 Thread Walther Koehler
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

Re: [libreoffice-users] Update a mailmerge file

2021-08-15 Thread 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

Re: [libreoffice-users] Update a mailmerge file

2021-08-15 Thread Robert Großkopf
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, just using > a file manager) Open the source Calc file, Make your edits and save. You

Re: [libreoffice-users] Update a mailmerge file

2021-08-15 Thread Michael H
Hi Robert, Thank you! Your hint worked, except 'refresh' had no effect, But the 2nd option on the arrow-circle button on the toolbar 'rebuild' did the job. I suspect thats because I had edited the source spreadsheet while Base was not open and added an empty first row to make it an index or key

Re: [libreoffice-users] Update a mailmerge file

2021-08-15 Thread Robert Großkopf
Hi Michael, > Is there a way to dynamically set up a Calc->Base->Writer mail merge so > that changes in Calc can be pushed through to Writer? I don't see how to do > it. Not dynamically, but some hints: You have to open the Base file before opening Calc. Wehen opening Calc you see it is write

[libreoffice-users] Update a mailmerge file

2021-08-15 Thread Michael H
Is there a way to dynamically set up a Calc->Base->Writer mail merge so that changes in Calc can be pushed through to Writer? I don't see how to do it. I've made a fairly complex mail merge file (some 25 fields). I added another 50ish items to the spreadsheet thinking I could refresh the mail