Le mer 28/05/2003 à 14:34, [EMAIL PROTECTED] a écrit : > From: Landy Atkinson <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Mailing Labels from MySQL database on web > Date: 27 May 2003 15:25:20 -0400
> What is the best way to approach this? As a temporary measure, I > used an auxiliary program (MySQL-Front running on a PC) to create a > CSV file on my PC which I e-mailed to the secretary along with > instructions on how to use the file in mail merge document in MS Word > to create labels. I thought about writing PHP code to create a CSV > formatted output on a web page which the secretary could copy and > paste into a document for the mail merge, but it seems there should > be a better way. > How about running OpenOffice.org on your sec's computer, and using the database facilities to do mail merge from there via the remote MySQL database. You can connect to the database via ODBC or JDBC, and OpenOffice.org has a labels wizard or template that can help you do this. It is even possible to run OpenOffice.org on the server as a headless display using an XVFB device, and then you could program it via the Basic or Java API to perform the work for you. Check out the mailing lists on the API, and UNO sections on the OpenOffice.org website for more info. Someone already has a PHP script to pass files to OOo to convert them to other formats, including to PDF. Alex Thurgood -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
