FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Suggestions » Newsletter-type feature  () 1 Vote
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Newsletter-type feature [message #11684 is a reply to message #11443] Sat, 12 July 2003 05:21 Go to previous messageGo to previous message
davew is currently offline  davew   Australia
Messages: 78
Registered: June 2002
Location: West Beach, South Austral...
Karma:
Member

prottoss wrote on Mon, 30 June 2003 02:34

davew wrote on Thu, 26 June 2003 20:52

I think this would be a very useful feature also!

How about a compromise? Would it be possible to output a text file containing the names & email addresses of people in any given group?

Then simply use the list in a mail-merge...



Simple query:
SELECT u.name, u.email FROM group_members gm INNER JOIN users u ON gm.user_id=u.id WHERE gm.id={group_id}.

You'll need to prefix table names with your sql table prefix and replace the group_id with the actual group id.



Cool! Thanks for that!
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Subscript/superscript extensions
Next Topic: Ask to join a group - is that feature present?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 13:24:28 GMT 2024

Total time taken to generate the page: 0.05342 seconds