Send bulk mail to calendar event attendees

[Fernando Mercês]

Hello,

Is there an easy way to send a bulk email message via dashboard only to people that confirmed their presence in a calendar event (RSVP)? I couldn't find it. That'd be a nice feature to have IMHO.

To accomplish this I did the following:

1. Created a new member group and copied its ID (14 in my case).

2. Got the attendees directly from the database. My event ID is 69, so I ran this SQL query via SQL Toolbox:

SELECT name,mgroup_others FROM core_members WHERE member_id IN (SELECT rsvp_member_id FROM calendar_event_rsvp WHERE rsvp_event_id=69 AND rsvp_response=1 AND allow_admin_mails=1);

3. I looked over the results and realized most attendees didn't have anything value in the field mgroup_others. For those who had any values, I copied to a text file to restore later. Then I've added them to the group created in step 1:

UPDATE core_members SET mgroup_others=14 WHERE member_id IN (SELECT rsvp_member_id FROM calendar_event_rsvp WHERE rsvp_event_id=69 AND rsvp_response=1 AND allow_admin_mails=1);

4. I restored the mgroup_others values for the members that had previous values.

5. I ran:

COMMIT;

6. Created a bulk mail and sent the e-mail message only to members in this new group. It worked. 🙂

How do you feel about this solution? Is it risky? Am I missing anything? @Developers, can you consider my suggestion?

Thanks,

Fernando

Edited April 28, 2020 by Fernando Pinheiro