Apache OpenOffice (AOO) Bugzilla – Issue 72818
Mail Merge ignores data source filter
Last modified: 2007-04-02 12:00:47 UTC
View>Data Sources on, select a data source, apply a standard filter. Click the Mail Merge wizard button. The Mail Merge wizard selects ALL rows in the data source, not just the filtered rows.
Reassigned to HI.
I've attached to issue 72821 three files that allow you to also replicate this issue 72818. Note: 1. I've left graphics in the Writer file in case they are part of the issue. Also I haven't adjusted them to position correctly in the output, so at some point you'll have to delete or move one or more of them to see the footers you need to. 2. I left all the rows in the spreadsheet. You can delete some to make it work faster, but it certainly causes the issue with all rows in. 3. You'll probably have to reconnect the database file and spreadsheet, and register the database. I named the database connection "TestMerge". Steps to reproduce: 1. Open the file <OOo Bug 72818 to 72821.odt> 2. Show data sources 3. Apply a Standard Filter, e.g. "Letter?" like 'Y' and click OK. 4. Click Mail Merge button 5. Click Next 4 times. 6. Preview the documents by clicking on the > or >| buttons. You'll notice that ALL rows from the data source have been included, not just those selected by the filter. 7. If you wish, you can continue as below to create the files and see that it creates one file for every data row, not just those filtered. 8. Click Next - OOo will now be creating the docs (VERY slowly!) 9. Click Next 10. Select Save Merged Document 11. Select From (will be 1 to 74 if you've used all rows in the spreadsheet) 12. Click Save Documents, select a directory in which to save them. I used prefix "TestMerge". 13. Note that on my system the output files vary in length as reported in Issue 72820, so some files will have nothing in them. Please let me know if you need any more information. regards - David
@dhislop: I did not try your example, but my own experience tells me that this report is invalid. There are 2 possibilities to filter for mail merge: 1. If you use the standard print dialogue for mail merge, you will be asked whether you want to print a mail merge letter (if the document contains mail merge address fields), and in this mode always the filter you used before printout will be respected. 2. If you use menu "Tools > Mail Merge Wizzard", you will have to filter in 'step 3 "Insert Address Block" > Filter' I checked with "2.2.0RC4 German version WIN XP: [680m14(Build9134)]", and everything worked as expected. So I believe we can close this issue as INVALID, or is there any hint in HELP or other documentation that for proceeding 2 the filter result of the data source editor should be relevant? @ufi I agree, this filter proceeding can't be found easily, may be HELP or UI should mention it in a prominent way.
"Tools > Mail Merge Wizard" works as you have described. My problem is that the filter does not work automatically from "View > Data Sources" when you press the Mail Merge button on the toolbar. That is, I would expect that if you have a filter active in the View > Data Sources pane, when you get to Step 3 "Insert Address Block", you shouldn't have to "Select Address List" because you already have it selected in View Data Sources, nor should you have to apply a filter from the Select Address List dialog. Maybe it's not possible to have it work that way? If not, then it needs to be made more obvious that viewing a data source and applying a filter is NOT sufficient to cause the filter to be applied when you press the Mail Merge button, and that you have to do it again in the wizard. regards - David
Should have added: this was OOo 2.2.0 I just tried it on. regards - David
I'll close this as invalid beacuse you can choose another database while proceeding mailmerge wizard. Feel free to file an enhancement for the part of help and ui.
closed.