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

Home » FUDforum » FUDforum Suggestions » Newsletter-type feature  () 1 Vote
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
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 01:21 Go to previous messageGo to previous message
davew is currently offline  davew   Australia
Messages: 77
Registered: June 2002
Location: West Beach, South Austral...
Karma:
Member
add to buddy list
ignore all messages by this user

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: Mon Mar 30 02:02:07 EDT 2020

Total time taken to generate the page: 0.00751 seconds