To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101997 Issue #|101997 Summary|Mail Merge won't populate fields from Speadsheet data. Component|Word processor Version|OOo 3.0.1 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|formatting Assigned to|writerneedsconfirm Reported by|jhd21181
------- Additional comments from [email protected] Sun May 17 05:55:58 +0000 2009 ------- 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. [email protected] --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
