Extracting name and addresses from postgres as a comma separated values "CSV" file should be doable with postgress utilities or scripts. Assuming you have access to a word processor like Microsoft Word, that has a "Mail Merge" capability, where your letter can be merged and printed with names and addresses from your CSV file. Factors affecting the wisdom of this approach are; * The volume of letters you expect to print and the printers you expect to use (bubble jet ink cartridges are expensive). * If name and address are the only substitutions in the letter. Greetings, additional content may require more that a CSV solution. * Special bulk mail requirements like zip code sort and selections should be doable in postgres. * For really large volumes you will need to break down the workload for multiple printers in a fashion that makes sense. If you want to reinvent the wheel by developing your own mail merge process, I would recommend against it, unless there is some significant gain by doing that. I'm guessing that your have already considered this, but are looking for some other solution for some reason that is not apparent to me. Good Luck, Warren Vail -----Original Message----- From: suma parakala [mailto:sumaparkala@xxxxxxxxxxx] Sent: Monday, October 04, 2004 11:23 PM To: php-general@xxxxxxxxxxxxx Subject: Help needed Postgresql and PHP Hi I am developing an application using php and postgresql . My problem is I need to retrieve name and addresses from table(postgres sql table) and print letter (body of letter will be same). Kindly help /Suggest how i can do this Thanks Suma _________________________________________________________________ Looking for a soulmate? http://www.shaadi.com/ptnr.php?ptnr=hmltag Log onto Shaadi.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
