Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199903

Re: [PHP3] Database to MS-Word via PHP3? (A little off topic) From: Alan Baer (abbaer <email protected>)
Date: 03/03/99

This solution wouldn't run ON an Unix server, but seems to do what you
want.

Excel has a "Query from web" option, and MS Word mailmerge integrates very
well with excel. (It's actually easier to use if the data is in Excel.)

So ... make a cgi in PHP that returns the fields you need from PostgreSQL.
Excel can hit this CGI and get the data. Then you can execute the mailmerge
in Word. You can write a macro that takes in the client name, does the rest
with a click.

Alan Baer

Matthew Hagerty wrote:
>
> Greetings,
>
> Sorry, maybe a little off topic.
>
> My client has a database of customers. My client also wants to be able to
> pull up a record on a client and sent a letter to that client. The letter
> would be canned except for the header and greeting. Does anyone know of a
> way to get field info into a word.doc file and print it from the same UN*X
> server running PostgreSQL? Any one ever do something like this? The app
> I'm developing is written in PHP3. It would also be nice to maybe be able
> to do minor editing of the merged file before it is printed. Asking to
> much? But this kind of thing should be very common, no?
>
> I cannot seem to find a good solution.
>
> Thanks,
> Matthew
>
> --
> PHP 3 Mailing List http://www.php.net/
> To unsubscribe send an empty message to php3-unsubscribe <email protected>
> To subscribe to the digest list: php3-digest-subscribe <email protected>
> For help: php3-help <email protected> Archive: http://www.php.net/mailsearch.php3
> List administrator: zeev-list-admin <email protected> 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>