Apache OpenOffice (AOO) Bugzilla – Issue 70581
Mail Merge Wizard empty inactive Mail merge fields, they are linked to the second inactive database
Last modified: 2013-02-07 22:35:28 UTC
If you use mail merge fields for 2 different databases in one document, make the mail merge wizard the fields, which linked to the second database, empty. The normal Serialprint, getting with STRG+P, print the existing value, thats the right way. The second database need i for quick userchange in one document. My user-database have many fields within Bank account, Tax number and much more for all sender information u need. My Files cant be used in the mail merge wizard. Please make that the mail merge wizard ignore all mail merge fields wich are linked to a second inactive database. Thank you. Regards Matthias Pester My first Staroffice was Staroffice 3.1, my last Staroffice was Staroffice 7.0, i am a Staroffice-User.
Reassigned to Requirements
Reassigned to HI
That won't be easy as long as only one databse can be defined to a document. Set to Enhancement.
>> That won't be easy as long as only one databse can be defined to a document. Set to Enhancement. My Answer: The Mail Merge wizard work in a other way as the serial print wizard, thats the one with the litte small window, and the one which print files with a filename taking from database. Open a Merge document and press cntrl+P to and say yes to get the primary mail merge wizard. The New mail marge wizard do it wrong and use more than one database. With the old one u can have many databases in one document and only one is active, thats the right way, for mail merge everybody need only one active database. But for the document usability u need 2 databases, one for the sender and one for the receiver. The Database of the sender is only active when u change the sender. If u have changed the sender, u must change the receiver database, to set the receiver database as active database for the document. To change the database, go to Edit>> Exchange Database, close there the user database and select the receiver database and select on the right side also the receiver database, and click at "Define". The active database is now the receiver database and the values in the fields of the sender database should be ignored by the mail merge wizard. But the new creation of mail merge wizard empty the fields of my sender database. I hope u can understand me now better, because u have me misunderstood before. The primary merge wizard in 2.0.4 can this what i want, and the new one isn´t able, thats the problem. Therefore i say it isn´t difficult to kill this error of the new buildet mail merge wizard. (The all wizard, creation and using). Ill tell u this because i want not that u go in a wrong way in future. Furthermore i need a personalized Subject from database (like the email address is taking from database), for "send merged document as email". Thank you for creation a Free Office application. I want help you to make a better one. Regards Matthias Pester
Created attachment 40007 [details] The User database Source
Created attachment 40008 [details] this is a piece of the main database for example
Created attachment 40009 [details] this is a mail merge document for example
1. create databases with the spreadsheets 2. exchange both tatabases, exchange the user database first time and the main database second time. See it self what the new mail merge wizard with the inactive mailmerge fields make. Ragards Matthias Pester PS: the mail merge document is not ms word....this is only my error while taking the upload wizard.