Le mer 28/05/2003 à 14:34, mysql-digest-help@stripped a écrit :
> From: Landy Atkinson <atkinson@stripped>
> To: mysql@stripped
> 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
