3

I would like to send an email to users who have submitted an abstract in the abstracts channel, but leave out users who have not submitted anything.

what would be the best way to achieve this?

I personally would just create a template, then have my abstract authors emails listed, and from there, ask my client to copy paste the list into his email app...

something like this:

{exp:channel:entries channel="abstacts"}
    {embed="_includes/_get_author_email" author_id="{author_id}"}
{/exp:channel:entries}

but I'm sure there's a better way to do this!
any thoughts?

3
  • Are you looking for a more direct way to get the email addresses? Or an automated way to actually send the emails? – Derek Hogue Dec 5 '12 at 17:47
  • If it's just to get the emails, then a custom query using the query module is probably your best bet – Jérôme Coupé Dec 5 '12 at 20:48
  • hi derek, optimally my client would like to have a checkbox, textarea, subject and a send button. or, even better, a checkbox list with all the emails, that he could choose which ones to send to... I guess with the answer from Iain and some template magic I should be able to sort it out! what's the best add-on to send emails from a template? is it postmaster? – outline4 Dec 6 '12 at 10:50
5

Easiest method is to use the query module and get the distinct email addresses from all the authors to a particular channel.

This would list all the emails for authors in channel_id 12

{exp:query sql="SELECT DISTINCT exp_members.email
            FROM exp_members
            LEFT JOIN exp_channel_titles
            ON exp_members.member_id = exp_channel_titles.author_id
            WHERE exp_channel_titles.channel_id = '12' "}
    {email}<br />
{/exp:query}

Simply swap out the 12 with the channel ID of your 'abstracts' channel.

2
  • 1
    Hi Iian! your query worked like a charm! thanks a lot! I'm impressed! – outline4 Dec 6 '12 at 10:45
  • @outline4 if Iain's answer solved your problem, make sure to mark it as "accepted" by clicking the little checkmark next to it. – janvl Dec 6 '12 at 15:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.