Handling SQL SELECT result

If you use an SQL SELECT sentence in any of the database actions available (MySQL, SQL Server or ODBC) Email Parser will automatically add to the available fields the retrieved data. For example:

Table name: parts
part_id	name	quantity
1	Screwdriver 5cm 234H	432
2	White scotch type	129
3	Black plastic panel	34

If you use the following SQL sentence:

SELECT part_id, name, quantity FROM parts;

The resulting fields are made available to the next actions:

With these set of fields you can then use Run a set of actions multiple times to launch actions for each fetched row.