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 som

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 don

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 f

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 pro

[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 mer