Apache OpenOffice (AOO) Bugzilla – Issue 101997
Mail merge wizard should 'exchange database' if necessary
Last modified: 2017-05-20 11:19:32 UTC
This is my first time sending in an issue. Please forgive me if I have not sent it to the right place, and let me know where I can send it. I use your OpenOffice Suite 3.0.1 program extensively for seeing my patients in Home Health, and use the Mail Merge program in MS Word to populate my notes that I print off or email to my home office. I would prefer to use your Mail Merge Wizard in Writer instead. I have created test odt and ods files which mimic my spreadsheet and note, but I am not sure how to attach them to this description so you can run them yourself to see the result. I would be happy to email them to you if you like. Here is the process: (1) Open the mail merge odt. (2) Choose Tools, then Mail Merge Wizard. (3) Choose radio button labeled "Use the current document" and hit Next>>. (4) Choose radio button labeled "Letter" and hit Next>>. (5) Choose Select Address List... button. (6) Under the Select Address List, choose the data base labeled Spreadsheettest from several data sources listed. (7) After a moment, under the table column, appears Sheet1. (8) Next choose the Filter button. (9) Under Standard Filter, choose Field Name- Date, Condition- like, and Value- type in 010109. Then press OK. Note in this test speadsheet there are only 6 records which match that value. (10) Back at the Insert address block page I double check to make sure that the Current address list: is Spreadsheettest. I then press Next>>. (11) At the Create salutation page, I press Next>>. (12) At the Edit document page I press Next>>. The Mail Merge small screen pops up and counts off the document 1...2...3..and so forth to 6 of 6. (12) The Personalize document screen appears and I press Next>>. (13) The Save, print or send screen appears. I choose the Save merged document radio button. A new menu appears below that of Save merged document, and I choose the radio button Save as a single document, and then press the Save Documents button. Type in Testresultmailmerge for the title and save the document. (4) I press the Finish button. Next I goto the above file and open it up. No data has populated the fields, and I have 11 pages (which should have been 6 pages) saved of blank forms. I would really like to stop using MS products (tired of the blue screen of death), and use you exclusively. Let me know what else I can do to help. I have replicated this same procedure on MS Vista, and Ubuntu 9.04 Linux with the same results. Thanks for the great job you do! Sincerely: Joel H. Du Mond III, R.N. jhd1181@yahoo.com
Created attachment 62317 [details] mailmergetest.odt
Created attachment 62318 [details] spreadsheettest.ods
Created attachment 62319 [details] testresultMailMergeodt
Can confirm it in OOo310m11 on WinXP. At first, I think if the page layout set as Only Right or Only Left, so the document has 11 pages, but now I deem it is an bug. Everyone, would you like giving me a hint? Set priority as P3, OS as All Regards Li Meiying
Workaround: After file opened, define the database first over: Menu Edit - Exchange Database... After database is defined, start MailMerge wizard Btw. You're still able to set the filter within the mailmerge dialog at step3. The problem with the page number is already present with issue 58919
Did the work around. It worked great. When I got the point in Mail Merge where I could edit the generated document, I pressed that button Edit document and went to the edit mode of the document. Next went to Print Preview and saw all of the extra 'blank' pages that showed up in the regular printer setting. I found that if I save the document as a PDF file, all the 'blank' pages disappeared. Using the PDF format, I could then print and/or email the document as needed. Thanks for all of your help: Joel H. Du Mond III, R.N.
@ jhd21181: thanks for your lates comment as well. Since it does work now, I suggest to close this issue as "Works for me". But when there is a clear proposal for better work flow / instruction to the user, we could change it to an Enhancement..
->cornouws: I wouldn't close it. The wizard should detect that there are database fields in the document that need to be assigned to the new data source. Changed target to OOo later, changed summary, was: "Mail Merge won't populate fields from Speadsheet data."
Reset assigne to the default "issues@openoffice.apache.org".