Re: [libreoffice-users] Fill Writer document with MySQL Query.
Very easy to do. Use Base to map to the data you want. If all the fields aren't one table then create a query that does generate the data you want and save the query. Use the mailmerge facility to create a document and connect to the data you want. Create fields for the data fields. Run the mailmerge and step something-or-other (four?) gives you opportunity to save your results, save the mailmerged result as separate Writer documents. Simples! Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Fill Writer document with MySQL Query.
I would like to create a "Writer" document where there are 3 items marked $NAME$, $DESCRIPTION$ and $PRICE$, each with its own font and formatting. This document will be a kind of template. Each of the 3 items will be replaced by a query to a MySQL database. The query will return 100 rows so there will be 100 separate "Writer" documents. Any suggestions as how to proceed will be appreciated. Thank you, Joe -- For unsubscribe instructions e-mail to: users+h...@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
