Distribution list from database

This forum contains features that has been archived. This section contains implemented features, duplicate requests, and requests which we have decided not to implement.
Post Reply

Do you need this feature?

Yes
3
100%
No
0
No votes
 
Total votes: 3

kevin@wine.co.za
New user
New user
Posts: 21
Joined: 2007-04-26 12:19
Location: South Africa
Contact:

Distribution list from database

Post by kevin@wine.co.za » 2007-09-20 10:55

A really nice feature I have seen in other mail servers is the ability to dynamically generate a distribution list from a database ( i.e) in the members tab you have the option to enter a sql statement that gets the relevant data ( name & eMail ) from a database - this then allows maintenance of the maillist through web forms etc.

^DooM^
Site Admin
Posts: 13862
Joined: 2005-07-29 16:18
Location: UK

Post by ^DooM^ » 2007-09-20 14:26

You can do this with any language that you can directly access the database with such as PHP.

kevin@wine.co.za
New user
New user
Posts: 21
Joined: 2007-04-26 12:19
Location: South Africa
Contact:

Post by kevin@wine.co.za » 2007-09-20 14:58

How? There is no option in the Administrator to 'link' a maillist to a sql statement?
The thinking is that you already have a database of email addresses, and you want to 'point' the members list at this list (select email from mydata )

kevin@wine.co.za
New user
New user
Posts: 21
Joined: 2007-04-26 12:19
Location: South Africa
Contact:

Post by kevin@wine.co.za » 2007-09-20 15:04

Take a look at the implimentation in Rocklifes Mailsite.
You can set up a maillist address - myclients@mydoman.com and then use a 'select eMail, name at mydatabase' statement (and possible an odbc connection if remote) to dynamically populate the members list. This is EXTREMELY powerfull, as the members list can then be maintained seperately as part of a companies normal database

Post Reply