I'm working on a POC for an email alert tool that would be triggered by an CMS admin when a new press release is posted on their website. I've decided to try and use MailGun awesomeness to do all the heavy lifting.
Scenario: Subscribers would register on the website with Name, Email Address, Company name, and check a few options for categories (lets say: News, Product, Financial).
Admin goes into CMS, publishes press release and triggers off email alert to the subscribers that have checked one (or more) of the above categories
My question: How should I best approach the categories? Both my ideas have issues:
Create separate mailing lists for each category and when an email is triggered, send to all matching lists. Problem: The subscriber will receive the same email multiple times (I hoped it it de-duplicate email addresses automatically, but it seems not to be the case)
Each category is added as a custom vars against the subscribers. Problem: I cannot see a way of filtering a mailing list based on these vars. Seems that are only good for putting custom varibles in the email messages.
Other than doing all the filtering myself and sending each message one-by-one, I can't think of another way of doing it in MailGun.