I'm working on getting one data extension to display for 3 email templates using content builder. Each email template will have different content within it, but I only want 1 email template to be sent to those on the data extension who meet my requirement.
My Data extension has the following columns:
FNAME LNAME COLOR Bob Smith blue Billy Idol blue Andrew Cowel red Jane Doe red Jenny Rodgers green Pat Martinez green
I want the following to happen:
Email template 1 to send only to emails that have the color blue in their row (but not to send to red or green) Email template 2 to send only to emails that have color red in their row (but not to send to blue or green) Email template 3 to send only to emails that have color green in their row (but not to send to blue or red)</blockquote>
I've seen this done with the Dynamic blocks within content builder, but I wanted to achieve this with my own ampscript code, if possible.