Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.