| View previous topic :: View next topic |
| Author |
Message |
hgomersall
Tux's lil' helper
Joined: 08 Jul 2002
Posts: 135
Location: Cambridge, UK
|
 Posted: Mon Feb 02, 2004 2:13 pm Post subject: email merge |
 |
|
I would like to be able to send out emails from my machine with content that is based on a PostgreSQL back end. It is actually a set of accounts, which contains billing information (list of transactions etc), from Gnucash.
Are there any free packages that would let me perform this task? If not, how might I do it?
Thanks
Henry |
|
| Back to top |
|
 |
db_404
Guru
Joined: 05 Dec 2002
Posts: 336
|
| Posted: Mon Feb 02, 2004 6:00 pm Post subject: |
|
|
If it comes to it, that doesn't sound too hard to do with a quick Python (Perl/Ruby etc..etc..etc..) script.
You'd just have a template doc, merge the data into the document, and send via your scripting languages smtp api. |
|
| Back to top |
|
|
kashani
Advocate
Joined: 02 Sep 2002
Posts: 2032
Location: San Francisco
|
| Posted: Mon Feb 02, 2004 9:14 pm Post subject: |
|
|
Heck it's even easier then that.
get data from db
process it into a file
cat file into sendmail which is a compatibility binary between all MTA's such as Postfix, Qmail, Exim, Sendmail, Courier and so on and address to a user.
Wash rinse repeat.
write script to process bounces. I suggest going with maildir format as it makes this step eaiser.
kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape. |
|
| Back to top |
|
|
|
Networking & Security
