Content for specific groups in one newsletter

Goal: send only one mail with specific content for every user depending on their group.

To achieve this you have to use the condition-tags in combination with SQL-recipient-lists.

Example SQL-recipient:

SELECT email,
FIND_IN_SET(1 ,fe_users.usergroup) as group_one,
FIND_IN_SET(2 ,fe_users.usergroup) as group_two
FROM fe_users
WHERE deleted = 0 AND disable = 0 AND tx_newsletter_bounce < 10;

Example newsletter-content:

Content for everyone

###:IF: group_one ### 
Content for group one
###:ELSE:###
Content not for group one
###:ENDIF:###

###:IF: group_two ### 
Content for group two
###:ENDIF:###

To be continued...

• automatic Conditions with TS
• more complex group-conditions