<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:blue;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-reply;
        font-family:Arial;
        color:navy;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>FYI: I’ll be working on adding this
functionality to project forena over the next few weeks. Basically it’s
form emails for an arbitrary sql query. Not sure if it will be ready in time
for you, but thought you’d like to know. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
support-bounces@drupal.org [mailto:support-bounces@drupal.org] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Vaibhav Jain<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, May 03, 2011 9:20
PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">support@drupal.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [support] Email to
all active users</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Hey Andre,<br>
<br>
This can be easily done by a custom module, just some simple queries and code,
and it will be done.<br>
You can select the active users from the database by referring to status field
in users table (1 is active, 0 is blocked), and email them whatever content you
want to.<br>
Also, if in case you want to send a drupal defined mail, these are stored in
variables table, so you can refer that as well.<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On Wed, May 4, 2011 at 8:55 AM, Andre Durudas <<a
href="mailto:durudasa@gmail.com">durudasa@gmail.com</a>> wrote:<o:p></o:p></span></font></p>
<div bgcolor="#ffffff" text="#000000">
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Thanks Sunil!<br>
<br>
The Rules module looks good for a variety of reasons. However, I don't think
it'll work for my purposes. I need something to send an email to all registered
active users on a manual trigger. With Rules, it seems, I can only define
automatic triggers.<br>
<br>
<br>
<o:p></o:p></span></font></p>
<div style='margin-left:30.0pt'>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center style='border-color:-moz-use-text-color -moz-use-text-color;
min-height: 1px'>
</span></font></div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<div style='margin-left:30.0pt'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><a href="mailto:sunildhimal@gmail.com" target="_blank">sunil dhimal</a><br>
<font color="#888888"><span style='color:#888888'>April 27, 2011 4:20 AM</span></font><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div style='margin-left:30.0pt'>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3 color="#888888"
face="Times New Roman"><span style='font-size:12.0pt;color:#888888'><br>
You Can use Rules Module <br clear=all>
Regards<br>
Sunil Dhimal<br>
<br>
<br>
<br>
<o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='margin-top:11.25pt;text-align:center'><font
size=3 color="#888888" face="Times New Roman"><span style='font-size:12.0pt;
color:#888888'>
<hr size=2 width="100%" align=center style='border-color:-moz-use-text-color -moz-use-text-color;
min-height: 1px'>
</span></font></div>
<p class=MsoNormal style='margin-top:11.25pt'><font size=3 color="#888888"
face="Times New Roman"><span style='font-size:12.0pt;color:#888888'><o:p> </o:p></span></font></p>
</div>
<div style='margin-left:30.0pt'>
<p class=MsoNormal style='margin-top:11.25pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><a
href="mailto:durudasa@gmail.com" target="_blank">Andre Durudas</a><br>
<font color="#888888"><span style='color:#888888'>April 26, 2011 3:23 PM</span></font><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-top:11.25pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<div style='margin-left:30.0pt'>
<p class=MsoNormal style='margin-top:11.25pt'><font size=3 color="#888888"
face="Times New Roman"><span style='font-size:12.0pt;color:#888888'><br>
Hello,<br>
<br>
is there an easy way to email all registered active users on a Drupal 7 site?
Any module for example? I could not find anything...<br>
<br>
Thanks,<br>
Andre<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal style='margin-top:11.25pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-top:11.25pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
<br clear=all>
<br>
-- <br>
Regards,<br>
Vaibhav Jain<o:p></o:p></span></font></p>
</div>
</body>
</html>