After usingLookupRowsto retrieve data when building a dynamic email, the next step before using this rowset within a FOR loop is touseRowCountto ensure the rowset contains data (D). This validation ensures that there are rows to iterate over, preventing potential errors or empty iterations in the FOR loop.
Example:
SET @rows = LookupRows("DataExtensionName", "FieldName", "Value") SET @rowCount = RowCount(@rows) IF @rowCount > 0 THEN FOR @i = 1 TO @rowCount DO SET @row = Row(@rows,
@i) /* process each row */ NEXT @i ENDIF
References:
* Salesforce Marketing Cloud AMPscript Guide
* AMPscript RowCount Function