Am 02.02.2012 01:52, sonic wrote:
Hi bro, Do you have any alternative ways to do in libre base.. directly is there any tutorial for doing mail merge in libre base. yes i found out already can upgrade or edit data in spreadsheet after registered the spreadsheet in base.. TQ regards, sonic
Once you have a Base document connected and registered, you can hit F4 in Writer, select the table or query you are interested in and then drag the column headers from the right pane of the data source browser into the document. This will import the required placeholders on the fly and you can arrange these database fields like any other type of Writer field. Then you start printing and confirm that you are going to print a serial letter. In the next dialog you may restrict the incoming row set by some filter or manual selection and you may choose to print into another Writer document. If you need some fixed filters (for instance all rows where name, zip, city and address are not empty), then you may add a query to the database document and use the query instead of the table. This is where it becomes very convenient that Base provides a database view on your spreadsheet tables.
-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted