loopMultiSelectPicklistValues.html

%%[
set @subscriberKey = AttributeValue(_subscriberKey)
set @subscriberRows = RetrieveSalesforceObjects(
   "Contact",
   "FirstName,LastName,Email,Preferences__c",
   "Id", "=", @subscriberKey )

if RowCount(@subscriberRows) == 1 then /* there should only be one row */
  var @subscriberRow, @firstName, @lastName, @email
  set @subscriberRow = Row(@subscriberRows, 1)
  set @firstName = Field(@subscriberRow, "FirstName")
  set @lastName = Field(@subscriberRow, "LastName")
  set @email = Field(@subscriberRow, "Email")
  set @Preferences__c = Field(@subscriberRow, "Preferences__c")
  
IF NOT EMPTY(@Preferences__c) THEN
    SET @rs = BuildRowsetFromString(@Preferences__c,';')
    
    IF rowcount(@rs) > 0 THEN
    
     FOR @i=1 TO rowcount(@rs) DO
      SET @val = Field(Row(@rs,@i),1)
      IF @val == "Surveys" THEN
      SET @Surveys = true
      ELSEIF @val == "Events" THEN
      SET @Events = true
      ELSEIF @val == "Newsletters" THEN
      SET @Newsletters = true
      ELSEIF @val == "Promotions" THEN
      SET @Promotions = true
      ELSEIF @val == "Special Offers" THEN       
      SET @Offers = true
      ENDIF
     NEXT @i
   
    ELSE
    
    SET @Newsletters = ""
    SET @Events = ""
    SET @Offers = ""
    SET @Survays = ""
    SET @Promotions = ""
    
    ENDIF
ENDIF

endif

]%%

@Surveys: %%=v(@Surveys)=%%<br>
@Events: %%=v(@Events)=%%<br>
@Newsletters: %%=v(@Newsletters)=%%<br>
@Promotionss: %%=v(@Promotions)=%%<br>
@Offers: %%=v(@Offers)=%%<br>