You can create a SharePoint Designer Workflow for this list which will trigger when item is created.
Start with an IF condition, if IsSubscriber == Yes --> then send email.
For sending email, use the 'Send Email' activity. In the To field, make a selection for 'Email' column to send email to the emailid mentioned in this column. And then mention the subject, body.
Publish the workflow and you are done.
=== EDIT ===
Please follow this -
Open 'SharePoint Designer'
Click on 'Workflows' section
Click 'List Workflow' -> Select List
Add if condition, after that
Click on 'Action' -> Select 'Send An Email'
In 'To' -> Click on 'Address Book' -> Click 'Workflow Lookup for a User'
Select entries like
Data Source - Current Item
Field from source = Email
Return field as = string