Send email to users who posted in specific sub-forum

[dutchbb]

What would be the best way to achieve this?

I want to send a mass email to all users who posted a thread in a specific sub-forum or who have an expired paid subscription.

[Simon Lloyd]

you'd need to query the database users table and join the serahc with the post table. The query for expired subscriptions should be easier.